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

#1

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

#2

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

"Ron" <Ron (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Running an exe as the last step and passing a parameter to it - 08-14-2005 , 06:58 PM

Re: Running an exe as the last step and passing a parameter to it - 08-15-2005 , 01:23 AM