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

LVL 6
anushahannaAsked:
Who is Participating?
 
John ClaesConnect With a Mentor Senior .Net Consultant & Technical AnalistCommented:
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
 
anushahannaAuthor Commented:
compatibility level is 90.
0
 
anushahannaAuthor Commented:
but CL of a DB should not matter with a SSIS package?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
reb73Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.