none
DTS packages in SQL Server 2012 RRS feed

  • Question

  • Will it be possible to run DTS packages in SQL Server 2012?

    Is there any msdn link for the same? I know in SQL server 2008 R2, we can DTS packages in Legacy mode.

     

    Tuesday, January 10, 2012 6:58 PM

Answers

All replies

  • As per the article :- http://technet.microsoft.com/en-us/library/bb500429(SQL.110).aspx

    It's been discontinued. So, you may want to first migrate the dts package to SQL server 2008 R2 and then probably to SQL server 2012.

    Even when I see the legacy folder in SQL server management studio for SQL 2012, I don't see DTS folder there but it used be there in 2008/2008 R2 .

     


    Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
    |Team Blog:- Team Blog
    • Marked as answer by MuditGupta Wednesday, January 11, 2012 3:03 PM
    Wednesday, January 11, 2012 1:08 PM
  • We have developed an access tool which allows to run DTS packages on SQL Server 2012.

    we are currently exploring options to market the tool.

    Please, leave me a message if you would be interested at:

    dts2012@web.de

    Best regards,

    Joe

    Friday, June 1, 2012 4:38 PM
  • after converting, my suggestion is to rewrite the packages as time goes by

    Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

    Saturday, June 2, 2012 5:21 AM