Tuesday, February 20, 2007

UPDATE - New Blog Site

I'm moving to a new blog site. Please note the new URL: http://www.ssistalk.com

Monday, February 19, 2007

SSIS bug submission and other resources

Many people over on the Microsoft SQL Server SSIS forum wonder what is the appropriate venue for submitting bug reports... For those who want to submit a feature request or to post bug reports, please visit the Microsoft Connect site. http://connect.microsoft.com/SQLServer

Also, keep tabs on Jamie Thomson's blog: http://blogs.conchango.com/jamiethomson/default.aspx
Rafael Salas also has a blog: http://rafael-salas.blogspot.com
Check out SQLIS: http://www.sqlis.com/
Matt Masson from the SSIS Team has a blog: http://blogs.msdn.com/mattm/

Tuesday, January 23, 2007

Derived Column

Notice that there are three different examples of how to work with the derived column... The first example uses a DT_WSTR column and outputs a NEW column with a data type of DT_WSTR. The second example does exactly the same thing, except the output data type for a second, new column is DT_I4 (integer). The third example actually replaces an integer column, ClientNumber with the values of the conditional expression.

If you are working on date fields, DT_STR input types can be implicitly cast to date data types. An example follows. The input column, [column10] is of type DT_STR.

Thursday, January 18, 2007

Flat File Issues

This post is in reference to the thread "Flat File Source Problem" over at the MSDN SSIS forums.

After taking the sample data, I saved it to a text file. When first creating the flat file connector, I got the same error, however I did not have a CR-LF at the end of the last line. I opened the file, went to the end and hit Enter and then saved the file. I recreated the flat file connector, specifying "Vertical Bar {|}" as the column separator and everything worked.