I have a dts package that creates a CSV file including today's date in
the filename. Once the file is created, I plan use an Execute Process
Task to call an app (ws ftp) that uploads the file to an ftp server.

I want to specify this filename as a parameter in the Execute Process
Task so I can upload the file that has just been created by the
previous ActiveX task.

How would I do that?
Thanks
Leslie

You could use something like this

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)

Allan

"les" <les> wrote

Thanks Allan, this function looks like it may be what I need, but
where do I enter it, and how do I refer to it in the Execute Process
task?

Thanks
Leslie


On Sat, 5 Nov 2005 09:25:44 +0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:

You use this script in an Active X Script task and it goes before the
ExecuteProcess task. The ExecuteProcess task does not need to know
about the script. The script is telling the ExecuteProcess task what it
will do.

Allan

"les" <les> wrote

That's great. Presumably I refer to the name of my execute process
task in the script:
set cus = pkg.Tasks("DTSTask_DTSCreateProcessTask_1").Custom task



On Sat, 5 Nov 2005 16:45:59 +0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:

Correct. Your task name may not be the same as the one I used in the
article.

Allan

"les" <les> wrote