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 - 2002-09-19 : 09:12:30
|
| Stephan writes "My application (SQLServer 7.0 sp2) runs five different dts packages from within five stored procedures using @HR=sp_OAMethod @DTSpkg, 'LoadFromSQLServer("Server1", "sa", , , , , , "dtsPackage1")'. After transferring the database and the packages to a new server, the packages won't run from the stored procedure. @HR = -2147024809.All packages run from the GUI. What's wrong?Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
|
|
|
Running DTS from stored procedure after transferring to another server 