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...
Technology
How to import data from DBF file into SQL server
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...
Warning: Null value is eliminated by an aggregate or other SET operation.
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...
First look at the Visual Studo 2008
Impact-Site-Verification: -975757908 I’ve installed trial of Visual 2008. At first look there’s no such big difference between this version and previous one. First one you can see when you create a project as you can below there’s no Business Intelligence projects,...
November Release Date for Visual Studio 2008
Finally Microsoft committed release date of Visual Studio. During Microsoft TechEd Developers 2007 corporate vice president of the Developer Division at Microsoft Corp., announced that Microsoft will release Visual Studio 2008 and the .NET Framework 3.5 by the end of...