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?

more ▼

asked Feb 24, 2011 at 10:22 AM in Default

avatar image

535 41 42 47

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

more ▼

answered Feb 24, 2011 at 10:23 AM

avatar image

40.9k 39 94 168

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, 2011 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, 2011 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, 2011 at 11:23 AM Oleg
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Feb 24, 2011 at 10:32 AM

avatar image

25k 3 13 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 24, 2011 at 10:22 AM

Seen: 1390 times

Last Updated: May 19, 2011 at 01:30 AM

Copyright 2018 Redgate Software. Privacy Policy