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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2010-04-14 : 13:56:02
|
| I am migrating SQL Server 2000 DTS packages to SQL Server 2008. I have saved the packages locally to my dev machine. I ran the Migration Wizard in VS2005 and all packages were successful. Next, I changed adjusted the data sources in connection manager to reflect the new server that I want the package to execute on. I get success when I test the data sources. Next, I go to save a copy of the package to the new server location. I get this error:TITLE: ------------------------------An OLE DB error 0x80040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_listpackages'.) occurred while enumerating packages. A SQL statement was issued and failed.------------------------------ADDITIONAL INFORMATION:An OLE DB error 0x80040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_listpackages'.) occurred while enumerating packages. A SQL statement was issued and failed.It seems like there is a missing stored procedure on the target server. How can I fix this?Thanks in advance - regards. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-15 : 02:13:57
|
Maybe the problem is I ran the Migration Wizard in VS2005?In 2008 the name has changed from sp_dts_listpackages to sp_ssis_listpackages.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-04-15 : 10:42:52
|
| I guess my next question is: where can I look for the existing sp_dts_listpackages command so that I can change to sp_ssis_listpackages?Regards |
|
|
|
|
|
|
error trying to save ssis package