Hi all,

I have many DTS scripts I've written over the years, and we're about to
start testing MS SQL 2005 to replace our 2000 servers. Any caviets
with me using my MS SQL 2000 DTS's with 2005? Can I just export to a
..dts file and import it into 2005? If I have to rewrite all this it'll
take FOREVER...

Thanks --

Sam

Sam,

Integration Services has an Execute DTS 2000 Package Task that allows
you to run DTS2000 packages. So, until it is a suitable time to revise
a package, you can include it inside a SSIS package unchanged.

Andrew Watt
MVP - InfoPath

On 4 Nov 2005 06:37:26 -0800, "Alex" <samalex (AT) gmail (DOT) com> wrote:

There is no reason you HAVE to change the packages at all. You could
try migrating them to 2005 but to tell you the truth they will run quite
happily in 2K5 using the "Execute DTS 200 Package Task"
You are then free to rewrite at your leisure. Will I be rewriting my
packages? Yes but I will do them one at a time. It makes sense to do a
rewrite rather than take an upgrade if your package is much more than
interesting

Allan


"Alex" <samalex (AT) gmail (DOT) com> wrote