SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 2005 DTS to 2008 SSIS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

v_kash
Starting Member

45 Posts

Posted - 09/11/2012 :  12:37:20  Show Profile  Send v_kash a Yahoo! Message  Reply with Quote
I hope someone can answer this - we currently are on 2005 Sql Server. We have 24 DTS Packages. We plan on upgrading to 2008 shortly. Does 2008 support DTS Packages? (is it backward compatible?). Or do all of these packages have to be re-written as SSIS Jobs? Thanks

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 09/11/2012 :  14:31:19  Show Profile  Reply with Quote
sooner or later you've get them rewritten to ssis packages. Currently you can export and maintain dts packages if you like inside sql 2005/2008 instances though you wont be able to edit/modify them.

In 2005 you've a dts designer component add in available which you can install if you really want to edit packages. Not sure whether a similar component is available for sql 2008 though!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 09/12/2012 :  02:08:26  Show Profile  Visit jackv's Homepage  Reply with Quote
Yes , there is support in SQL Server 2008 R2 for running DTS- http://msdn.microsoft.com/en-us/library/ms143755(SQL.105).aspx

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 09/12/2012 :  11:32:20  Show Profile  Reply with Quote
quote:
Originally posted by jackv

Yes , there is support in SQL Server 2008 R2 for running DTS- http://msdn.microsoft.com/en-us/library/ms143755(SQL.105).aspx

Jack Vamvas
--------------------
http://www.sqlserver-dba.com


ok...thats cool
Does this work in 64 bit versions as well?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 09/12/2012 :  15:45:05  Show Profile  Visit jackv's Homepage  Reply with Quote
Not to my knowledge. There is no 64 bit compile.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 09/12/2012 :  15:45:46  Show Profile  Reply with Quote
ok..thnx for the confirmation

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 09/13/2012 :  01:41:49  Show Profile  Visit jackv's Homepage  Reply with Quote
your welcome

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000