SSIS flat file loading - data type conversion -- sql server dts

nkw
4/24/2007 8:06:00 AM

It seems I can do the type conversion in two place:

1. The advanced editor for flat file source => Input and output properties.
And I can set the output columns data type properties there.

2. Using a Data conversion box in Data flow transformation.

Allan Mitchell
4/24/2007 7:59:04 PM

Hello nkw,

You can actually do this in a 3rd place. You can do this on the Connection
Manager itself. You get the opportunity there to define the columns or have
the component "Suggest Types" instead of everything being a DT_STR(50)

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

sql server dts : SSIS flat file loading - data type conversion