Running a Package from Stored Procedure

#1

I would like to run a package while passing it a variable from a stored procedure. The xp_cmdShell method isn't working because dtsrun is working from the command line. Is there another way?

#2

Hi,
Go thru this article

http://www.databasejournal.com/featu.../article.php/1
0894_1459181_1

Cheers,
Yash

Quote:

-----Original Message-----
I would like to run a package while passing it a variable
from a stored procedure. The xp_cmdShell method isn't

working because dtsrun is working from the command line.
Is there another way?

Quote:

.

#3

Just to be clear, there is no reason that you cannot use DTSRUN from
xp_cmdshell. The OLE stored procedure method that Yash linked to does offer
potentially more flexibility, but it can be problematic in it's own right.

--
Darren Green
http://www.sqldts.com
"TomTait747" <TomTait747 (AT) discussions (DOT) microsoft.com> wrote

Quote:

I would like to run a package while passing it a variable from a stored
procedure. The xp_cmdShell method isn't working because dtsrun is working

from the command line. Is there another way?

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

Running a Package from Stored Procedure

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

Running a Package from Stored Procedure - 07-19-2004 , 05:26 PM

Running a Package from Stored Procedure - 07-20-2004 , 01:46 AM

Re: Running a Package from Stored Procedure - 07-20-2004 , 02:58 AM