dts from ssis 2008

Is there a way we can access and run the DTS packages using SSIS-2008, as if we can do using SSIS-2005?

asked Feb 24 '11 at 10:22 AM in Default

srivivek
519 ● 30 ● 39 ● 42

(comments are locked)

2 answers:

Yes, you can import legacy DTS in SQL Server 2008.

answered Feb 24 '11 at 10:23 AM

Tim
31.5k ● 20 ● 31 ● 116

SQL Server 2008 has a limited support for DTS. If you have 64-bit installation then SSIS has to run in 32-bit mode. This link leads to the article explaining how to install run-time support for DTS

Feb 24 '11 at 10:28 AM Oleg

Thanks for the add on Oleg. I have learned all to well the issues with 64bit OS and SQL with SSIS especially support with Excel. Not sure why Microsoft chose to not provide full 64bit support.

Feb 24 '11 at 10:32 AM Tim

@TRAD The rumor has it that while there are no 64-bit drivers for Excel 2003/2007, Microsoft has developed 64-bit drivers for Excel 2010. The only trouble is that you can install either 32 OR 64-bit driver on the box, but not both. It kinda makes sense as they have to have some ways to enforce people to upgrade to the latest version of Office :)

Feb 24 '11 at 11:23 AM Oleg

(comments are locked)

The same compatibility components you use with SQL Server 2005 have been updated to work with SQL Server 2008. They are part of the SQL Server Feature Pack

Here is the relevant section:

Microsoft SQL Server 2005 Backward Compatibility Components
The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with both SQL Server 2005 and SQL Server 2008 and include all fixes shipped through SQL Server 2000 SP4 and SQL Server 2005 SP2.and SQL Server 2005 SP2.