Migrating DTS packages to SQL Server 2016

sql-server dts
Errorhere picture Errorhere · Feb 3, 2016 · Viewed 8.7k times · Source

I need to migrate all the DTS packages to MS SQL Server 2016. What are the contents of DTS pacakages. Are there any differences in SQL statements like Insert, Update, Delete etc. What are the things I should be aware of to upgrade the DTS packages to SSIS? How I can migrate DTS packages to SQL Server 2016?

Answer

Bobby picture Bobby · Feb 7, 2016

I am not sure if Microsoft provided Migration Wizard in SQL 2016 to migrate DTS to SSIS but I know for sure that its an option in SQL 2005 and 2008. So your best bet could be migrate to SSIS using some SQL 2005 or 2008 installation (Use DTS Migration Wizard). Once packages are in SSIS 2005 or 2008 format its very easy to upgrade them to SSIS 2016 format....

Word of caution.... DTS and SSIS is very different and no upgrade wizard can be full proof so there will be lot of hand edits specially if you have ActiveX scripts in DTS.

If its not too much code in DTS then this would be good opportunity to re-write it so you can learn SSIS.

Related questions

How to create an SQL table and and populate it with Excel spreadsheet data?

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool? Thanks in advance.

Read More
DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component. Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record …

Read More
SSIS Transfer Database task cryptic error message 0x80131500

I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am developing directly on the destination server (not optimal, but it works). When I try to use the Transfer database task, …

Read More