Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSMS Error: could not find stored procedure 'dbo.sp_dts_listfolders'. RE: SSMS Error: could not find stored procedure 'dbo.sp_dts_listfolders'.

  • March 21, 2010 at 9:41 pm

    #1137399

    The error is happening because

    1. the name of various SSIS related sprocs changed in SQL 2008 ("DTS" finally becomes "SSIS")

    2. by default, SSIS 2005 looks at the default SQL instance on the server, which for you is a SQL 2008 instance.

    Hence, even though can find the sprocs, you are looking in the named instance of SQL 2005.

    To fix this , you will need to edit "MsDtsSrvr.ini.xml" which is in a path similar to "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\" (depending on your particular installation). In this file, is the name of the sql server instance that SSIS uses for it storage (i.e. the location of the MSDB database for it to use). By default, this is "." which is the default instance on the server. Change this to the name of your instance (e.g. "myServerName\InstanceName") and restart the SSIS service.