Store Procedures and DTS

#1

Hello,

Can someboby tell me how to execute a DTS package from
inside a Store Procedure.

Thanks
J

#2

You can use xp_cmdshell to call the DTSRun utility, for syntax look in BOL

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Julie" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,

Can someboby tell me how to execute a DTS package from
inside a Store Procedure.

Thanks
J

#3

Thanks Ray (again) ;-D

J

Quote:

-----Original Message-----
You can use xp_cmdshell to call the DTSRun utility, for
syntax look in BOL

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Julie" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:027601c3a771$ac216a80$a001280a (AT) phx (DOT) gbl...
Hello,

Can someboby tell me how to execute a DTS package from
inside a Store Procedure.

Thanks
J

.

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

Store Procedures and DTS

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

Store Procedures and DTS - 11-10-2003 , 04:01 AM

Re: Store Procedures and DTS - 11-10-2003 , 04:21 AM

Re: Store Procedures and DTS - 11-10-2003 , 05:00 AM