Post reply

Deriving filename/location in SSIS

  • May 17, 2010 at 2:35 pm

    #1168455

    What is the current value of your variable... if you left it blank.. Enter a Filepath(preferably the text file path that you have used in the DFT). You need to use Findstring and SubString Functions to get the FileName from your complete path.. Fro more help post your path here..

  • May 17, 2010 at 5:18 pm

    #1168528

    I used the SSIS|Variables menu item to set the value of my variable to H:\James\Intex_to_Securities\Test_Source_Files\AAM0301.csv. I get the same error I did before.

  • May 17, 2010 at 6:24 pm

    #1168539

    I think I got this Foreach Loop to work, thanks!

Viewing 3 posts - 16 through 17 (of 17 total)

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