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 |
|
jsmith
Starting Member
24 Posts |
 Posted - 2004-04-08 : 06:10:38
|
| Has anyone been able to get the step.GetExecutionErrorInfo method working via sp_OAMethod.I've used the following:EXEC @retval = dbo.sp_OAMethod @step_hndl, 'GetExecutionErrorInfo', @errorno OUT, @src OUT, @desc OUTThis gives the following error:ODSOLE Extended Procedure: Error in parameters, or attempt to retrieve a return value from a method that doesn't supply one.Any help greatly appreciated. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-04-08 : 07:10:22
|
| The error info method needs a reference to variables but as t-sql doesn't allow stongly typed variables in ole SPs this isn't possible.I usually call a VB loader to run DTS packages if I want to get error info.Another option is to set the package to log the result to a file, bcp in the data from that file then parse it for the error info.==========================================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. |
 |
|
|
|
|
|
sp_OA DTS Automation