Executing DTS package

[tbailey922]

Hello,
Does anybody know how to run a DTS package that is created in SQL Server. I want to transfer data from one table to another when the user hits a button. Program was written in VB.net.

Thanks
Tim

 

[NoCoolHandle]

The trick here is how was it saved..
Local Package/Structured Storage File etc...

The command you are looking for is DTSRUN

look it up either on the web or in SQL server books online.

It is a standalone executable that can run any of the types of DTS you have, just get the correct parameters


ROb

 

[chrissie1]

it looks something like this
you need to make sure the user has execute rights on the master database and dtsrun. this is an sqlstatement wich you have to run.

EXEC master.dbo.xp_cmdshell 'dtsrun /Sservername /Npackagename /E'

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting