Is there an easy way to more a large number of dts packages from one server
to another?

thanks

mike w.

Yep

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)



"mike w." <mikew (AT) discussions (DOT) microsoft.com> wrote

Another question:
After the (or during the) transfer of large number (about 100) of dts
packages from one server to another is it a easy way to change global
variables in each DTS package.

Thank you.
Leonid

Allan Mitchell wrote:

You wouldn't do this at transfer time.

The global variables should be set externally at run time or set to look
externally themselves at runtime.

When you change a GV value at runtime it is only valid for that run. If
you want to persist the value then you would need to save the package
with that version of the GV


Allan

"zina" <leonid.yakhkind (AT) tycohealthcare (DOT) com> wrote

Allan,

I have 100+ DTS packages that is copying from production to the dev
server.
Each package has a 3 Global Variables (GVs): 1.Source_fille_path; 2.
error_fille_path; 3. DB_Connection_String. All of the them have are
same value in each package.
On the development server all 3 GVs need to be change to new values -of
the development box.
Is it the only way to manualy open each DTS and change GV values?
Thank you.
Leonid

No.

Ideally you build a package and never open it again. Your GVs should be
set to either read from an external source their values or you call the
package through the object model and set them that way.

Have a look at the dynamic Properties task.

Allan

"zina" <leonid.yakhkind (AT) tycohealthcare (DOT) com> wrote

Thank you.

I've found couple good articles about using the Dynamic Properties
task:

http://databasejournal.com/features/...le.php/3073161
http://www.sqldts.com/default.aspx?252


Allan Mitchell wrote:

Hi Mike,

here's how we did that ( we unintentionally ) :

insert into msdb.dbo.sysdtspackages ([name], [id], [versionid],
[description], [categoryid], [createdate], [owner], [packagedata],
[owner_sid], [packagetype])

(select * from neuintdbsql1.test1.dbo.sysdtspackages where name like
'EXCEL%')



HTH

Meinhard

"mike w." <mikew (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
newsB0085E6-DF8F-45EC-89B8-A0413A810B00 (AT) microsoft (DOT) com...