by Tomasz Szulczewski | Nov 25, 2013 | SQL server
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...
by Tomasz Szulczewski | Apr 12, 2013 | SQL server
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″]...
by Tomasz Szulczewski | Mar 8, 2013 | SQL server
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,...
by Tomasz Szulczewski | Sep 15, 2009 | SQL server
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...
by Tomasz Szulczewski | May 30, 2008 | Microsoft, SQL server
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...