| Author |
 Topic  |
|
|
v_kash
Starting Member
43 Posts |
 Posted - 09/11/2012 : 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
India
47173 Posts |
Posted - 09/11/2012 : 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 MVP
http://visakhm.blogspot.com/
|
 |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1772 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1772 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 09/12/2012 : 15:45:46
|
ok..thnx for the confirmation
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1772 Posts |
|
| |
Topic |
|
2005 DTS to 2008 SSIS
