Hi All,

Our partner created a DTS package in sql 2000. However, we are still
running sql 7 and can't upgrade in the short term. Is there anyway to
open that DTS package in sql 7 or somehow "save" the package in sql
2000 as a sql 7 version?

Or is this mission impossible?

Thanks,
bluemug

So long as you have SP3 on the 7 box and the 2000 package is not using 2000
only tasks.

if you do not have SP3 then make sure you save the 2000 package with a
password

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"bluemug" <jianyangtai (AT) gmail (DOT) com> wrote

There is also a Developer edition of SQL 2000 for $50 that may be worth
considering if you absolutely need to get at that package. It would at least
let you open it to see what's in there, even though you couldn't legally
develop something with it.

Allan's suggestion below is better overall, but this may be another option for
you...

-Pete

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote: