dbTalk Databases Forums  

Batch for Transfering multiple DTS packages from one server toanother on SQL server 2000.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Batch for Transfering multiple DTS packages from one server toanother on SQL server 2000. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
KrisC
 
Posts: n/a

Default Batch for Transfering multiple DTS packages from one server toanother on SQL server 2000. - 12-29-2008 , 11:11 AM






We create DTS packages on development server and try to move the
packages to test servers.
We first extract the packages and save them as some kinds of binary
files.
When we are importing these packages to another servers we have to
rename them according to the server name.

Now we can only import each package one by one from the saved file. We
then have to enter username and password for each package.

I am looking for ways to be able to ease our work and let us to import
these packages by using either a batch file that is flexible enough to
let us alter the packages name and owner and stuff.

Please help me with this issue or direct me to some related posts or
articles.

Much appreciated.

Thank you.

Reply With Quote
  #2  
Old   
Paul Ibison
 
Posts: n/a

Default RE: Batch for Transfering multiple DTS packages from one server to ano - 01-08-2009 , 09:23 AM






Hopefully this'll help: http://www.sqldts.com/204.aspx
Paul Ibison, www.replicationanswers.com


Reply With Quote
  #3  
Old   
KrisC
 
Posts: n/a

Default Re: Batch for Transfering multiple DTS packages from one server toano - 01-15-2009 , 09:53 AM



thank you, the solution that we are using right now is to install VB6
and save all packages into BAS extension.
However, this is only able to transfer the package but not the design
comments, and the layout of the DTS pacakge will be changed to default
after the VB code is ran.

Anyway, Thanks for the help.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.