SQL Server 2008 SSMS crashing opening DTS package

  • I have moved DTS package from SQL Server 2005 to SQL Server 2008.

    SQL Server 2008 SSMS is crashing when I open the DTS package..

    I have installed sql server 2005 backward compatibility feature SQLServer2005_BC_x64 after sql server 2008 installation.

    Please advise.

  • Can you explain what you mean by crashing?

    Are you getting an error message?

    Is the package not working?

    Is SSMS just closing when you try to run the package?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Are you trying to RUN the package or OPEN it? You should be opening it with Business Intelegence Development Studio.

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

  • When I goto DTS package and right click and open, then SSMS is crashing in sql server 2008.

    Please see the attachment.

    Thank you

  • Try this article:

    http://jasonbrimhall.info/2010/07/07/sql-2008-dts/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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