April 25, 2011 at 5:17 am
hi,
i am a newbee to SSIS. i created a a for-each file loop which runs through the folder c:\test. in this folder i have multiple files which need to be processed. for this, i added a Execute process task inside the loop container and i am calling vb .exe file which does the processing of the files one by one.
what i need to do is to pass the current filename in the Loop as an argument to the execute process task such that the vb .exe file receives the filename as a command line argument and processes the file.
i tried putting the filename variable in the Argument option of Execute Process task. also tried selecting the filename as Input Parameter. But still not working. please help
April 25, 2011 at 3:30 pm
This video demos the ForEach Loop container in SSIS which may be able to help you to arrive at a solution:
http://www.sqlshare.com/looping-through-and-loading-files-with-ssis_34.aspx?searchid=155499
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply