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.
| Author |
Topic |
|
BeginnerBob
Starting Member
2 Posts |
 Posted - 2005-09-07 : 12:23:05
|
| Hi, I need a hand to run a DTS package through a stored procedure.Does any one know how to do this with out saving the package as a Structured storage file.Cheers.Bob. |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-09-07 : 12:47:44
|
| You can use the sp_OAcreate procedures to instantiate the DTS object model in your stored procedure and run a package that way. All of the examples I See on the web are loading the file from storage (either a file or from SQL Server), but sp_OA* allows you to use any object model from a procedure, so you shoudl be able to do anything you want :)Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
lancepr
Starting Member
17 Posts |
Posted - 2005-09-07 : 17:39:50
|
| You need to have your SP in the master DB then do somehting like this:Exec master..xp_cmdshell 'DTSRUN /Slocalhost /NdtsPackagename /E'GO/S=server/N=DTS package/E= use trusted connection |
|
|
|
|
|
|
Run DTS through Stored Procedure