none
DTS Package compatibility on Windows 2012 R2 server RRS feed

  • Question

  • Hi,

    Can we run DTS Package on windows 2012 R2 server with SQL 2008 using backward compatibility?.

    Thanks,

    Sri.

    Wednesday, March 15, 2017 10:32 PM

Answers

  • Can we run DTS Package on windows 2012 R2 server with SQL 2008 using backward compatibility?.

    Hi, yes you can. You'll require SQL Server 2005 Backward Compatibility Components and SQL Server 2000 DTS Designer Components.
    • Marked as answer by Sridevms Thursday, March 16, 2017 9:26 AM
    Wednesday, March 15, 2017 11:16 PM
  • It should work. The version of the OS is not relevant here. Are you getting an error message?
    • Marked as answer by Sridevms Thursday, March 16, 2017 9:27 AM
    Wednesday, March 15, 2017 11:25 PM

All replies

  • Can we run DTS Package on windows 2012 R2 server with SQL 2008 using backward compatibility?.

    Hi, yes you can. You'll require SQL Server 2005 Backward Compatibility Components and SQL Server 2000 DTS Designer Components.
    • Marked as answer by Sridevms Thursday, March 16, 2017 9:26 AM
    Wednesday, March 15, 2017 11:16 PM
  • It should work. The version of the OS is not relevant here. Are you getting an error message?
    • Marked as answer by Sridevms Thursday, March 16, 2017 9:27 AM
    Wednesday, March 15, 2017 11:25 PM
  • Thank you Kevin!
    Thursday, March 16, 2017 9:25 AM
  • Thank you Hilary!

    I just wanted to confirm before moving into windows 2012 server.

    Thanks.

    Thursday, March 16, 2017 9:26 AM