Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
v_kash
Starting Member
45 Posts |
 Posted - 2012-09-11 : 12:37:20
|
| 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
52326 Posts |
Posted - 2012-09-11 : 14:31:19
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-12 : 02:08:26
|
| Yes , there is support in SQL Server 2008 R2 for running DTS- http://msdn.microsoft.com/en-us/library/ms143755(SQL.105).aspxJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-12 : 11:32:20
|
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).aspxJack Vamvas--------------------http://www.sqlserver-dba.com
ok...thats coolDoes this work in 64 bit versions as well?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-12 : 15:45:05
|
| Not to my knowledge. There is no 64 bit compile.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-12 : 15:45:46
|
| ok..thnx for the confirmation------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-13 : 01:41:49
|
| your welcomeJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
2005 DTS to 2008 SSIS