Post reply

SQL Server 2008 SSMS crashing opening DTS package

  • May 15, 2012 at 3:36 pm

    #258272

    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.

  • May 15, 2012 at 8:11 pm

    #1488141

    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

  • May 15, 2012 at 9:29 pm

    #1488148

    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.

  • May 15, 2012 at 9:37 pm

    #1488149

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

    Please see the attachment.

    Thank you

  • May 16, 2012 at 5:58 am

    #1488315

    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