Converting DTS packages in SQL 2K to SQL 7.0

[Dynapen]

Here's the question. I have created a DTS package that imports about 45-60 tables from a oracle database. I created the package in SQL Server 2K Enterprise edition. The problem is that I have to backwards convert it into a SQL 7.0 package.

Any ideas on how to do this?

Can i simply write it out into a SQL Script, and then import it again?

Any help would be greately appreciated.

 

[fluteplr]

I have not had much luck getting them to go backwards. It seems to be easier to redo it in 7. BTW If you install the client tools from 2000 on the 7 server, you can use the 2000 DTS stuff. Plus the 2000 version of enterprise manager works alot better. I have done this on several server and it does not seem to have any effect on the running of the 7 server.

 

[Dynapen]

fluteplr-

Thanks for the advice. That sounds like what i am gonna have to do. That isn't really a problem for me, but I have others i need to give the package to that might not be able to do that.

Just as a add on, anyone had any problems converting from 7 to 2K? I am probably just gonna up my server, as opposed to just loading the client tools.