sql server dts: How to change the owner of the source/destination tables within a preexisting DTS package -- sql server dts

How to change the owner of the source/destination tables within a preexisting DTS package

Alex Castillo
10/10/2007 5:14:07 PM

sql server dts:

Hello.

Running MS SQL 2000, we designed time ago a couple of DTS packages to move a
lot of data from one database to another. Later after, we had to change the
ownership of those tables, and we changed Servers (also ServerNames) as
well.

Is there an easy way to move the DTS packages to the new Server and to
modify them to adjust to the new Server Names and table owners?

Thanks..!

Re: How to change the owner of the source/destination tables within a preexisting DTS package

jhofmeyr NO[at]SPAM googlemail.com
10/11/2007 12:00:00 AM

On Oct 10, 11:14 pm, "Alex Castillo" <AlexCast_SlwMx-at-HotMail-dot-
[quoted text, click to view]

Hi Alex,

I'm not sure if there's a better way to do this, but I've always moved
packages by exporting the data for the required packages from the
sysdtspackages90 table (in MSDB) on the old server and inserting it
directly into the same table on the new server. You need to be
careful that the data does not conflict with any existing package data
on the new server, and I always make sure that the two servers have
exactly the same version of SQL Server as well.

As to changing the servernames/owners .. if your packages have been
built to make use of the dynamic properties task to assign these
values, it should be a simple matter of changing the values in
whatever configuration mechanism they were built to use. If the
values are hard-coded you'll have to edit each package and change the
values manually.

Good Luck!
J

Disclaimer: Any modification to data in the systems tables should be
done with extreme caution, and at your own risk!