SSIS Script

• mxwebb

  SSC Eights!

  Points: 886

  More actions

  October 30, 2008 at 11:51 am

  #193055

  Need help with the syntax for a Script that Set a Variable.

  I have a Variable being sent in at Run time. FileName = FileName.txt

  I need to use this variable to set a variable called DestinationTableName.

  Something like DestinationTableName = Right(FileName,4)

  This should strip off the .txt and Set DestinationTableName = 'FIleName'

  Thanks!!! for all your help don't know what I would do without you guys/gals

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  October 30, 2008 at 4:59 pm

  #892118

  Try this:

  Dts.Variables("DestinationTableName").Value = System.IO.Path.GetFileNameWithoutExtension(FileName)