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 not valid for use in specified state.". You may not … [Read more...] about Failed to decrypt protected XML node.
I spent a few hours to find solution for my last project. I had to import data from old DBF files into SQL server. I made such things a few years ago with SQL server DTS, but In SQL server integration services (SSIS) it must be done in different way, but when you know how to do this, it's simple. To create connection to DBF file you have to chose as a provider: “Native OLE … [Read more...] about How to import data from DBF file into SQL server
Have you received such error? I’ve got in my SSIS package something like this: “Hresult: 0x00040EDA Description: "Warning: Null value is eliminated by an aggregate or other SET operation.". End Error Error: 2008-01-12 12:02:52.75 Code: 0xC0047038 Source: STR3c-sells DTS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB … [Read more...] about Warning: Null value is eliminated by an aggregate or other SET operation.
I’ve passed today Microsoft exam 070-228 in Installing, configuring and administration Microsoft SQL server 2000. My score is 811 (maximum was 1000). I was thinking for a few years about that and finally I decided to do this. Now I thinking about next one and I plan to pass it in next two months. [adblockingdetector id="5770e6ed85560"] … [Read more...] about Now I’m MCP