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 - 2006-02-16 : 08:04:37
|
| Mike writes "I followed the steps outlined in http://www.sqlteam.com/item.asp?ItemID=12653, and I cannot make it work. I'm getting this error from -- Execute Package EXEC @oleStatus = sp_OAMethod @oPackage, 'Execute'800403ED: No Steps have been defined for the transformation Package(I put in code to catch this in the stored proc.)It sounds to me as though the code that runs the DTS package cannot find any steps in the DTS package, and yet, when I look at it, there it is.I believe I'm using all the appropriate passwords, etc. I also noticed that when I go into the package and manually set the globals, and then execute the step within the package, it works just fine.I really need this to work for a pretty major project I'm working on. It almost sounds like a problem with the package properties, but I can't figure out what.Any ideas?Thank you." |
|
|
|
|
|
Executing DTS from a stored procedure