Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
File Inserter Transformation
By Allan Mitchell
Version 2005
Level Intermediate
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7

Double click now on the SQL Server destination adapter. For the Data Source you can either specify an existing Data Source pointing to our destination table or you can create a new one just like we did with the OLEDB Source adapter. On the mappings section we need to specify what from our source is going to what in our destination and as you can can see we have the column that holds our filename and the new output column we created in the File Inserter transform. Simply drag the source columns to their respective destination columns and we're done.

DEd
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7
Related Articles & Links
Read File Transformation