copying DTS package 2

[jammic25]

I have created aprox. 40 DTS packages that I would like to copy to a remote SQL server. The 2 SQL servers can not directly communicate with each other. Is there any way to accomplish this?

 

[DLanouette]

You can save all the packages to file (a time consumming task) and copy them to floppy or whatever then import them on the second machine.

I'd write some vb script to save all of them to file in one fell swoop. The code's not too hard. If you have trouble, email me off-line.

Sorry, but that's about your only solution.

HTH


______________________________
- David Lanouette
- Lanouette Consulting, LLC
- DLanouette@Computer.org

 

[hlazzaro]

The solutions is to save all the DTS as files. Then you must open each DTS file in the Enterprise Manager from each Server and save it in the database.
You can also run each DTS as file with the comand DTSRUN.

Hans Lazzaro
DW and BI Consultant
hlazzaro@blgate.cl