SSIS - Script Component

  • Hi All,

    I am looking to use the Script Component to import a flat file and add a blank column to it .. where I will enter data from the other columns from the same file using code.

    Can you suggest the basic steps to me ..

    Many thanks,

  • Reading the flat file can be done using a flat file connection manager and a flat file source.

    Adding a blank column can easily be done with the derived column.

    If the code isn't complex, you can also fill in the new column with the derived column.

    If the code is too complex, then use your script component as a transformation:

    http://msdn.microsoft.com/en-us/library/ms136114.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply