SSIS

UPDATE - New Blog Site

2007-02-20T00:15:00.000-06:00

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

SSIS bug submission and other resources

2007-02-19T16:24:00.000-06:00

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/

Derived Column

2007-01-23T09:36:00.000-06:00

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.

Flat File Issues

2007-01-18T09:19:00.000-06:00

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.