x

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

srivivek gravatar image

srivivek
519 41 42 43

(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

Tim gravatar image

Tim
36.4k 38 41 139

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][1] to the article explaining how to install run-time support for DTS

[1]: http://msdn.microsoft.com/en-us/library/ms143755.aspx
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][1]

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.

[1]: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c
more ▼

answered Feb 24, 2011 at 10:32 AM

KenJ gravatar image

KenJ
20.3k 1 4 12

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1850
x943
x66

asked: Feb 24, 2011 at 10:22 AM

Seen: 1211 times

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