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 |
|
Nick
Posting Yak Master
155 Posts |
 Posted - 2003-01-26 : 16:05:57
|
| Hello-I am running a DTS package from a stored procedure by using something likeexec master..xp_cmdshell 'dtsrun /servername /Npackagename /Uuser /Ppassword'It works fine, but I was wondering if there was a way to tell if the package completed successfully or if there wan an error. I think runnig the sproc returns a recordset, but I'm not sure what to check for to see if it completed without any errors. Can anyone help?Thanks-Nick |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-26 : 17:57:06
|
| You can load and run the package using the object modelseewww.nigelrivett.comLoading DTS package via sp_oacreateYou can then interrogate all the objects within the package to find any errors and what they are.==========================================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. |
 |
|
|
Nick
Posting Yak Master
155 Posts |
Posted - 2003-01-26 : 20:59:44
|
| I understand most of the code, but what is @FileName? |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-26 : 22:09:10
|
quote:
Global Variables for the packageServerNameDatabaseNameFileName
|
|
|
|
Nick
Posting Yak Master
155 Posts |
Posted - 2003-01-27 : 00:08:51
|
Yeah I saw that. Two of the variables are self explanitory to me, and in fact needed to use them the way I was handling this before. FileName was not needed before and isn't immediately obvious what purpose it serves in this context.quote:
quote:
Global Variables for the packageServerNameDatabaseNameFileName
|
|
|
|
|
|
|
Check DTS Status From sproc