• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2732
  • Last Modified:

Could not find stored procedure 'msdb.dbo.sp_dts_listpackages'

when i try to add a package in a sql job, i get the following error.

this is sql 2008- why would it check for sp_dts_listpackages?

msdb does have sp_ssis_listpackages.
===================================

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.


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)
   at Microsoft.DataTransformationServices.DTSExecUI.Controls.GeneralViewCtrl.<>c__DisplayClass4.<buttonBrowse_Click>b__0(String path)
   at Microsoft.DataTransformationServices.DTSExecUI.Controls.GeneralViewCtrl.buttonBrowse_Click(Object sender, EventArgs e)

===================================

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.


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
   at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

Open in new window

0
anushahanna
Asked:
anushahanna
  • 4
2 Solutions
 
anushahannaAuthor Commented:
compatibility level is 90.
0
 
anushahannaAuthor Commented:
but CL of a DB should not matter with a SSIS package?
0
 
John ClaesCommented:
Information:
msdb.dbo.sp_dts_listpackages: returns the list of packages in 2005
msdb.dbo.sp_ssis_listpackages: returns the list of packages in 2008

when adding a package the stored procedure "sp_dts_listpackages" is indeed called.
it is executed when expanding the list of packages in SSMS
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
reb73Commented:
Are you sure you are using a SQL Server 2008 Management studio?
0
 
anushahannaAuthor Commented:
2005 SSMS SP3
0
 
anushahannaAuthor Commented:
thanks- that was it.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now