blogs.conchango.com

News just in… Microsoft have purchased Zoomix, a data quality software vendor. From the press release: Zoomix will contribute a critical layer of data improvement to Microsoft's SQL Server Data Platform Interesting stuff. One would think this will sit fairly and squarely within SSIS given that SSIS will be shipping Data Profiling ...

Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing has completed: A) Check to see whether there has been any data that could not be ...

In my blog entry Custom Logging Using Event Handlers from June 2005 I described an easy technique for using SSIS eventhandlers to get more useful logging information from your packages than using the out-of-the-box logging providers and up to now it has proved to be one of my most popular blog entries. With the introduction of the ...

  That’s what I twittered recently upon first opening up Release Candidate 0 of SQL Server 2008. You may remember that back in March of this year I told you about a new feature that would be appearing in a future CTP; namely that a container would provide information about its parent container. Hence if you peer into the depths of this ...

Quick note. Doug Laudenschlager (I've checked and rechecked the spelling - I think that's right :) from the SSIS team has begun a SSIS related blog at Dougbert.com (RSS feed). Doug is the technical writer on the team which means that he writes all the SSIS documentation in SQL Server Books Online. Hence, what Doug doesn't know about SSIS really ...

SSIS uses absolute paths to point to objects on the file system. What does that mean? In short it means that in order to point to a file I would have to use the full absolute path, I couldn't give a path that is relative to where the packages resides. A common complaint about SSIS is that it does not allow the use of relative paths. The most ...

There's some good news filtering into my inbox today about SQL Server bugs that have been fixed in the upcoming CTP (i.e. CTP6).Title: SSIS: Raw files throw an error at 4GB Description: It is not possible to load more than 4GB of data into a raw file. Status: Resolved (Fixed) Link: ...

Just like Andrea Merkel, Tottenham Hotspur and Britney Spears' career, the Lookup task in SSIS 2005 is in serious need of a makeover. Whilst it is one of the more useful components in the SSIS toolbox it has a number of shortcomings including: Inability to dynamically build the SQL statement that populates the cache when in 'Full Cache' mode ...

''Why the <insert your favourite expletive here> doesn't SSIS support C# for the script task and script component?''   I've heard the above complaint, in various different ways, many many times over the past 18 months since SQL Server 2005 was released. Its a valid complaint to which there is a valid answer (which I'm not going ...

Here's a useful page to keep an eye on: http://msdn2.microsoft.com/en-us/library/ms403408.aspx. It lists the current features within SSIS that will be disappearing in future versions and the strongest message I take from it is that you should upgrade your existing DTS packages from SSIS sooner rather than later. Currently it also makes ...