SSIS ScriptTask Or Derived Column

• mxwebb

  SSC Eights!

  Points: 886

  More actions

  July 18, 2008 at 8:47 am

  #381792

  I have a Flat File Connection to connect and loop through file with a for each loop.

  In the process I extract data from the file then push it SQL table.

  Before I push each record in that file I need to Add a Field.

  the trick before I add the field I need to Strip two digits from the file Name put those two digit in a Variable Then Add the new field with a Derived Column.

  My issue at what point should I do this.

  Before the data conversion? or after?

  Then what object to use to First Strip the file name and set Variable

  I was hoping I do it all in a look up object with an expression. That don't seam Possible?

  So What I would Set @File_code = Strip(FileName)

  Then Set @Carrier_ID = Lookup(Carrier_ID)

  Thank you very much!

• hodgy

  SSCertifiable

  Points: 5906

  More actions

  July 28, 2008 at 5:23 am

  #849083

  You can always use a variable to hold the stripped characters, and set it to be evaluated as expression.

  Then, add this variable as a derived column.

  Tom

  Life: it twists and turns like a twisty turny thing