Downgrade DTS Package

All
Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
imported into SQL Server 7. If so what is the process to migrate a SQL
Server 2000 DTS Package to SQL Server 7.
Thanks
Backwards migration is not supported... You could create a script in SQL 2k
and try to load it,,, fixing any issues that you find... Or you could simply
start from scratch in SQL 7
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"David" <David@.discussions.microsoft.com> wrote in message
news:143BA10B-AAD6-4A76-B178-726FDA00EB75@.microsoft.com...
> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can
> be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.
> Thanks
|||Try
save DTS package as Visual Basic file
open in VB and modify the following section of the code
'----
' Save or execute package
'----
goPackage.SaveToSQLServer "SQL7SERVERNAME", "sa", "your SQL 7 sa password"
'goPackage.Execute
'tracePackageError goPackage
'goPackage.Uninitialize
Run the vb program.
Thanks & Rate the Postings.
-Ravi-
"David" wrote:

> All
> Is there a way to downgrade a SQL Server 2000 DTS Package so that it can be
> imported into SQL Server 7. If so what is the process to migrate a SQL
> Server 2000 DTS Package to SQL Server 7.

> Thanks
sql