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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-31 : 08:42:39
|
| Le bon Vivant writes "Hi gurus,I am trying to run a dts package from a stored procedure and this is how I do it:exec master.dbo.xp_cmdshell 'dtsrun /SPraxis11 /Uadmin /Pfred /NpakProcessSalesCube'. If do this from the command prompt window using the same string, it works fine, but if I run the stored procedure, I get the following error:Error: -2147221005 (800401F3); Provider Error: 0 (0)Error string: Invalid class stringError source: Microsoft Data Transformation Services (DTS) PackageHelp file: sqldts80.hlpHelp context: 713What does this error mean? And why do i get it only when I call the stored procedure?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-31 : 12:46:09
|
| When you run it from the command line you are running the package on your local machine. The SP is running it on the server.The other possibility (especially if they are the same m/c) is the user that the sp is running the package under - probably the sql server service profile.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Runing dts package from stored procedure.