Running DTS packages on SQL Server 2012

ssis sql-server-2012 dts
Gabe picture Gabe · Jun 7, 2013 · Viewed 19.5k times · Source

I read that DTS packages aren't supported in SQL Server 2012. I know there's a Backward Compatibility package/option out there that we used for SQL Server 2008R2 to run DTS packages. Will that Backwards compatibility package not work for SQL Server 2012?

For 2008 R2 http://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx

Answer

Pondlife picture Pondlife · Jun 7, 2013

As the documentation says, support for "migrating or running" DTS packages was completely discontinued in SQL Server 2012. Even if you convince your customers to move to SQL 2012, you'll have to upgrade the packages to 2008 first and then upgrade again to 2012, so the sooner they agree to upgrade to some newer version the better, although I appreciate that - rightly or wrongly - many customers will not see the point in paying to upgrade something that still works.

Related questions

SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that …

Read More
SSIS: I don't see the package configuration wizard

Using SQLServer 2012 Enterprise, I don't see "Package Configuration Wizard" in SSIS when I do a right click in Control Flow tab. I can see all the other items (Log, Digital Signing...). Here are info about my install: Microsoft Visual Studio 2010 …

Read More
Which user credentials does Integration Services Catalog use to execute packages?

We have an SSIS package which reads text files from a shared network directory. When I execute this package in SSDT it works fine. When we however deploy the project to the Integration Services Catalog and attempt to run the …

Read More