Some of the data needs to be formatted/converted in a certain way
There are always several choices for performing conversions in your data flow.
You can certainly perform many of them in the source query. This has some advantages: if you are familiar with SQL it is easy to do, and it utilizes the SQL engine for the conversion, rather than passing "raw" data for conversion in the client (SSIS in this case.)
You can also perform conversions using the Data Conversion component http://msdn2.microsoft.com/en-us/library/ms141706.aspx and the Derived Column component http://msdn2.microsoft.com/en-us/library/ms141069(SQL.90).aspx.
Finally, the script component provides a great deal of flexibility for formatting values using Visual Basic.Net.
Donald
When using Books Online please remember that you can add comments (and vote) using the controls at the foot of the Books Online page - this will help us to improve the documentation for future use.
