I have a Data Warehouse, in which the data is loaded once a day and during the rest of the time the data does not change.

There are several heavy reports in SSRS used to cater data to the users, and it really saves the day to c…

Long story short: I have a SSIS data transformation task which takes some data from a table and inserts it in a different table.

So far so good. But the problem is that the data source in my transformation relies on a quer…

För er som som missade att få ett smakprov av kommande SQL Pass Summit 2011, nämligen 24 Hours of PASS så  finns det nu möjlighet att se dessa sessioner i lugn och ro. Många av sessionerna var mycket bra och nu finns det m…

Många företag har en gammal last av kod som rullar och som man inte vet riktigt hur man ska hantera. Andra har livscykelhantering av systemet och kanske i alla fall har en plan för om, hur, när och till vilket pris man ko…

Here is a very cryptic error message which managed to puzzle me a bit:

”The package failed to load due to error 0xC0010014 ”One or more error occurred. There should be more specific errors preceding this…

If you have passed the first levels od SSIS developmente and maintenance, and have started to look for new ways to use, explore and maintain packages, look no further than to http://ssisctc.codeplex.com/

Highligh…

When deploying a SSIS package from pre-production to production system I get a message ”The AcquireConnection method call failed with error code 0xC0202009.”

What I know is that this particular erro…

The other day I was faced with the task of giving a user full access to their own jobs wich run SSIS packages, while (of course) avoiding to make them a member of the sysadmin server role. The server version was SQL Server…