DTS Package Migration in SQL 2000

[Giri Palakodeti]

I have created a DTS package on my TEST server in SQL 2K. I want to move this
package to PROD. I cannot script and hand over it to my DBA.

What is the best practice and I have only package to move to prod.

Thanks in anticipation

[Russell Fields]

Giri,

If you save your DTS package as a Structured Storage File, it will create a
file that can be given to your DBA. He can then either edit it and resave
it in the production SQL Server, or just run if from the file.

Of course, it is also likely that some references, such as the connections,
may need to be updated.

FWIW, although storing in SQL Server has some advantages, because of the
issues of deployment as well as more than one person having rights to update
the DTS package, I almost always use Structured Storage Files. (Of course,
that means managing the security properly for the folder where your DTS
package is stored.)

RLF

Post by Giri Palakodeti
I have created a DTS package on my TEST server in SQL 2K. I want to move this
package to PROD. I cannot script and hand over it to my DBA.
What is the best practice and I have only package to move to prod.
Thanks in anticipation