Monthly Archives: February 2008

February CTP for SQL Server 2008

Posted on February 20, 2008 by jwelch

The February CTP for SQL Server 2008 has been released, and is available to download at https://connect.microsoft.com/SQLServer/. Microsoft is also sponsoring a bug bash contest, with prizes for the most bugs, most critical bug, etc. The rules are posted here: … Continue reading →

Posted in Uncategorized | Comments Off on February CTP for SQL Server 2008

Bundling Errors in the Data Flow

Posted on February 19, 2008 by jwelch

I’ve posted about handling multiple errors in SSIS before, but that post was addressing it in the context of the control flow. What if you want to capture a series of data errors from the data flow? An example of … Continue reading →

Posted in Uncategorized | Comments Off on Bundling Errors in the Data Flow

Adding Headers and Footers to Flat Files

Posted on February 8, 2008 by jwelch

A common question with SSIS is how to handle adding headers and footers to a flat file when the format is different that the data rows. This gets more difficult when the header or footer needs to contain data based … Continue reading →

Posted in Uncategorized | Comments Off on Adding Headers and Footers to Flat Files

Importing Files Using SSIS

Posted on February 2, 2008 by jwelch

A topic that has come up a few times recently is the idea of loading a set of files into a database using SSIS. One of the data flow components in SSIS is the Import Column transform, which allows you … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on Importing Files Using SSIS