Running SQL 2000 written DTS against SQL 7

Is this possible? That is, write a DTS in 2000, taking advantage of
new features, like Multiphase Datapump, FTP datasource, etc, and run
it on a SQL 7 box?
I read somewhere that the DTS libraries are portable, but will they
coexist with SQL 7? If so, can I also schedule them using SQL 7? Or
can I just run it on Task Scheduler once I save it as a VB app?
Thanks in advance!
JoelSQL Server 2000 packages can be run on a 7 server so long as there are
NO 2000 specific features.
If you UPGRADE 7 - 2000 then the client tools are migrated to 2000 and
the DTS Designer then becomes a 2000 designer.
Joel N. wrote:
> Is this possible? That is, write a DTS in 2000, taking advantage of
> new features, like Multiphase Datapump, FTP datasource, etc, and run
> it on a SQL 7 box?
> I read somewhere that the DTS libraries are portable, but will they
> coexist with SQL 7? If so, can I also schedule them using SQL 7? Or
> can I just run it on Task Scheduler once I save it as a VB app?
> Thanks in advance!
> Joel
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org