Post reply

DTS packages are not showing up in Enterprise Manager

  • July 13, 2010 at 11:01 am

    #75573

    Hello,

    I have a server that will not show the DTS packages in Enterprise Manager. I can see all the packages in sysdtspackages in the MSDB database, but they will not show up in Enterprise Manager. I can create new DTS packages and save them to sql server, but again they will not show up.

    Has anyone experienced this, or have any guidance?

    Thanks for you assistance.

  • March 11, 2011 at 12:32 pm

    #1297851

    When this happened on my servers it was the server's firewall blocking it.

  • March 14, 2011 at 6:53 am

    #1298290

    Thanks for the response. Unfortunately I don't believe that applies to us as we have two SQL Servers, one production and one backup. DTS packages still show in the backup server and the two servers are configured identically.

    Thanks again.

  • March 14, 2011 at 7:03 am

    #1298294

    I think it is related to service packs.

    Please try to configure the latest service packs on both the servers and see if you are able to view the DTS packages. Try running below command on both instances and see the result.

    SELECT CONVERT(sysname, SERVERPROPERTY('ProductLevel'));

    GO

    M&M

  • March 14, 2011 at 7:07 am

    #1298298

    Mohammed,

    Thanks for the reply. Both servers are currently patched @ SP4. SQL Server 2000 Enterprise Edition.

  • March 14, 2011 at 7:36 am

    #1298309

    By any chance do you have the client tools configured from where you can connect to this instance on which you are unable to view the DTS packages.

    I had faced this problem before and it was due to service pack.

    M&M

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply