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
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
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
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
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 decrypt protected XML node “PassWord” with error 0x8009000B “Key
I'm an IT lover, unrealized journalist, and fan of Freelancer Way and Microsoft Security Ninja. Do you have a problem with your company’s security? You don’t know how to start managing company devices? Do You Have a Specific Microsoft 365 Problem?
I am Here to Help!
