How to Migrate DTS packages between servers

[Philip Yale]

I'm quite new to DTS, and have to modify a number of existing local
DTS packages as part of an ongoing development project. Naturally,
I'm doing these on a test server first, but so far I've failed to find
any utility which will simply copy the package definition from the
test server to the live one (or any other server, come to that)

Since some of these packages are quite complex, it is going to be very
laborious (and error prone, surely?) to have to re-write these locally
on the production server.

Is there a way of doing this, or am I missing the point somewhat?

[Simon Hayes]

ph********@btopenworld.com (Philip Yale) wrote in message news:<e9**************************@posting.google. com>...

I'm quite new to DTS, and have to modify a number of existing local
DTS packages as part of an ongoing development project. Naturally,
I'm doing these on a test server first, but so far I've failed to find
any utility which will simply copy the package definition from the
test server to the live one (or any other server, come to that)

Since some of these packages are quite complex, it is going to be very
laborious (and error prone, surely?) to have to re-write these locally
on the production server.

Is there a way of doing this, or am I missing the point somewhat?

There is a tool here:

http://www.sqldts.com/?242

But it might be worth creating your own deployment scripts in
VBScript, Perl or whatever, using the SQLDMO object model to move
packages about - there are methods for loading to and from both files
and SQL Server.

Simon

[Simon Hayes]

ph********@btopenworld.com (Philip Yale) wrote in message news:<e9**************************@posting.google. com>...

I'm quite new to DTS, and have to modify a number of existing local
DTS packages as part of an ongoing development project. Naturally,
I'm doing these on a test server first, but so far I've failed to find
any utility which will simply copy the package definition from the
test server to the live one (or any other server, come to that)

Since some of these packages are quite complex, it is going to be very
laborious (and error prone, surely?) to have to re-write these locally
on the production server.

Is there a way of doing this, or am I missing the point somewhat?

There is a tool here:

http://www.sqldts.com/?242

But it might be worth creating your own deployment scripts in
VBScript, Perl or whatever, using the SQLDMO object model to move
packages about - there are methods for loading to and from both files
and SQL Server.

Simon