Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Passing Argument from Execute Process Task (SSIS)

Author  Topic 

kissa49
Starting Member

10 Posts

Posted - 2010-11-16 : 14:08:24
Hello,

I have a batch process set up, which executes fine as long as the name of the file is built in. My Execute Process task in SSIS also runs this batch file with succes.

I would like to pass the name of the file as a parameter from the Task (SSIS) to this batch file. Looks like I am doing something wrong because it is failing.

This is the batch file:
C:
cd \Program Files\WS_FTP Prowsftppro -s "local:D:\Folder1\Folder2\%1" -d HDMS:/To_HDMS/

--- The %1 is the parameter

The argument that I am passing in is in the 'StandardInputVariable'

Would really really appreciate some help! Thanks so much!

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2010-11-21 : 13:30:43
Cross post with answer:http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/6b893df2-cc15-4f28-93f1-aa798e8bf9fd





Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page
   

- Advertisement -