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 ...

SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are going to see in future versions. I was chatting to Rob Farley recently and we started to wonder ...

In the past I have advocated (and still do advocate) the use of a user variable in SSIS packages to store the path to a folder on the hard drive; I always use a variable called @[User::RootFolder] for this. Having this path available within a package variable enables you to dynamically set the location of files that your package may reference ...

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 ...