Can you move a DTS package from SQL 2000 to SQL 7.0?
Thanks.

Yes, but make sure you are on SQL 7.0 SP3+ and you have not used any SQL
2000 only features.


--
Darren Green
http://www.sqldts.com
"Rob" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks Darren.

The last time I tried opening a simple DTS package in SQL
7.0 SP4(select and export rows to an excel file), which
had been created in SQL 2000 SP3A, I encountered an error
(can't recall the exact error but I think SQL Server
complained about not being able to find the file). Thanks
again.

- Rob.

In message <1d6f01c4d7c5$3c7caf70$a501280a (AT) phx (DOT) gbl>,
anonymous (AT) discussions (DOT) microsoft.com writes
"The system cannot find the file specified" - probably because you had
used a SQL 2000 only task.


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


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org