I have a number of packages that I need to move from one server to another.
However, I also need to add owner and user passwords to each package. I am
trying to find out if I can do this from the back end by select the records
(DTS packages) and inserting them into the destination servers' system table.
For adding the passwords, would I be able to run an update on the system
table for the two fields?

Any info on this would be appreciated.

Thanks

You cannot run an update on the system table to give your package a
password.

You could use the object model top open the package then save to the
other server specifying the passwords you require. This will lose all
pretty layouts

You could Also do this through EM. This will keep the package layouts.

Allan

"Munch" <Munch (AT) discussions (DOT) microsoft.com> wrote

Thanks Alan.

Are you sure you can't run an update on the system table. The passwords
must be stored somewhere, and the table should be able to be updated. I will
investigate more.


"Munch" wrote:

Be my guest to try but I wouldn't hold out much hope

"Munch" <Munch (AT) discussions (DOT) microsoft.com> wrote

The passwords are stored as part of the binary COM Package object. The
format of this object is the same as how the DTS Package2 object exists in
memory. Perhaps you could save identical packages (structured storage
files) several times to determine offset values of where the password is
saved... then use a hex editor to compare multiple files. remember that
the package and version GUIDs will change on every save. By no means an
easy task...

-Mike Gercevich

--
Message posted via http://www.sqlmonster.com