question

srivivek avatar image
srivivek asked

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?
sql-server-2008ssisdts
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Tim avatar image
Tim answered
Yes, you can import legacy DTS in SQL Server 2008.
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image Oleg commented ·
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
1 Like 1 ·
Tim avatar image Tim commented ·
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.
0 Likes 0 ·
Oleg avatar image Oleg commented ·
@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 :)
0 Likes 0 ·
KenJ avatar image
KenJ answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.