Debugging SQL Server integration services solutions A few months ago I wrote a post about problems when you use 32 bit driver in 64 bit SQL Server. Now I had to face another problem linked to this solution. We made an upgrade of existing SQL Server 2008 R2 version to SQL Server 2012. Unfortunately after that my SSIS package which was used to import data from Oracle database … [Read more...] about Debugging SQL Server integration services solutions
Today I get strange error when I made new cube for SQL Server 2008 R2 analysis services. My cube simple just three dimensions and a few measures. I’ve created as always role for my users and grant them “Read” right [adblockingdetector id="5770e6ed85560"] Part of the settings was “Enable read permission” on “Cell Data”. For me it was obvious that it will allow user to … [Read more...] about #n/A in SSAS cell
Yesterday I had to load some data from Oracle database to my SQL Server 2008 R2. And as many of you my laptop runs 64 bit version of Windows. Task seems to be simple. When you try to use Oracle Ole DB for the first time from Business Intelligence Development Studio, you’ll get message that you have to install the driver first. So why it’s looks as installed??? Ok, I have to … [Read more...] about SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR
Today I’ve faced strange problem and I spent a few hours to solve it. I’ve installed my new SharePoint 2010 sever for development – nothing special. But when I created first top level site and try to display it http://ServerName I get error: ”Cannot connect to the configuration database”. What’s up? I’ve tried different things: reset passwords, delete and create managed account … [Read more...] about Cannot connect to the configuration database.
I create new ETL package with SQL Server Integration Services 2005, and I was thinking that nothing can surprise me, but It seems that I was wrong. My package contains simple date parameter which I would like to pass to sql command source. But every time I’ve pressed parameters button I get message: Parameters cannot be extracted from the SQL command. The provider might not … [Read more...] about SQL Command Parameter in SSIS.