blogs.conchango.com

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

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

Since Kirk Haselden left the SSIS team his former colleagues have been conspicuous by their absence from the blogosphere. So good news, Matt Masson has joined the SSIS team and is blogging. His rss feed is here: http://blogs.msdn.com/mattm/rss.xml for those that like subscribing to these things. -Jamie