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...
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...
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,...
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...
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...
I had strange problem with SSIS package. I made my package in Visual Studio, all tests ran without a problem at PC station. But when I upload it to production SQL server 2005 machine job failed… What’s going on? Error message was strange: “Description: Failed to...