sql server dts: Running an exe as the last step and passing a parameter to it -- sql server dts

Running an exe as the last step and passing a parameter to it

Ron
8/14/2005 3:58:01 PM

sql server dts: I know this is probably something simple but I'm not up on DTS packages. I
have a package that runs once a week and then I have to manually run a third
party program to update a warehouse. The warehouse program needs an M passed
to it to show it's an update to the warehouse and not a complete rebuild. How
can I add a new last setp to this package to execute this program with an M
parameter?

--
Ron

Re: Running an exe as the last step and passing a parameter to it

Allan Mitchell
8/15/2005 12:00:00 AM

Does the third part app in question have a cmd line interface? if it does
then you need to look at the Execute Proces task.

This article should give you some ideas.

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

Allan

[quoted text, click to view]