Running the DTS inside Stored Proc

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Running the DTS inside Stored Proc

Author

Topic

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-05-01 : 13:34:35

Hi Gurus
How can we run DTS package wriiten in active x script inside a stored Procedure.Please help
Nitin

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-05-01 : 13:53:28

Execute a package from T-SQL:
http://www.sqldts.com/default.aspx?210

CODO ERGO SUM

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-05-01 : 14:04:41

Hi
i am nt getting the syntax right ..can you please tell me to how to use it wil xp_cmdshell
Regards
nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-01 : 14:08:35

EXEC master.dbo.xp_cmdshell 'dtsrun.exe -SSomeServer -NSomeDTSPackage -E'

Check the syntax for dtsrun in SQL Server Books Online. Article is called "dtsrun Utility".

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-05-01 : 14:18:34

Hi Tara&Michael
Yeah just got it

CREATE PROCEDURE runpackage as
exec xp_cmdshell 'dtsrun /Sservername /Narchivereal /E'
It worked..Thanks again Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources