Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Batch for Transfering multiple DTS packages from one serve..

 
   Database Help (Home) -> DTS RSS
Next:  Duplicate Address Deletion  
Author Message
KrisC

External


Since: Dec 29, 2008
Posts: 2



(Msg. 1) Posted: Mon Dec 29, 2008 9:11 am
Post subject: Batch for Transfering multiple DTS packages from one server to
Archived from groups: microsoft>public>sqlserver>dts (more info?)

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.

 >> Stay informed about: Batch for Transfering multiple DTS packages from one serve.. 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 145



(Msg. 2) Posted: Thu Jan 08, 2009 7:23 am
Post subject: RE: Batch for Transfering multiple DTS packages from one server to ano [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

 >> Stay informed about: Batch for Transfering multiple DTS packages from one serve.. 
Back to top
Login to vote
KrisC

External


Since: Dec 29, 2008
Posts: 2



(Msg. 3) Posted: Thu Jan 15, 2009 7:53 am
Post subject: Re: Batch for Transfering multiple DTS packages from one server to [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.
 >> Stay informed about: Batch for Transfering multiple DTS packages from one serve.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
transfering Parameters to SSIS - Hello there I have SSIS process which load data from excel and xml and set the data on my database. Sometimes i change the name of file or directory where the imported files are exist. Can i: 1. send parameter from sql where i run the SSIS which..

transfering data between two servers - Hello here how can i transfer data of tables from server1 to server2 with SSIS while the data on server1 is being loced by transaction? can i set on ssis with (nolock)?

Export DTS Packages - Hi, I have an application that has aroubd 100 DTS Packages. I want to backup my DTS packages. Is there any easy way of exporting the packages other than that of opening each package and saving it as a .dts file. -- Thanks Akber.

DTS packages - I am working on extracting data from one table to a text file. 1. I need to count the number of rows I get after the extraction (not during) 2. I need to save the row count in a file (that is appendable) 3. The file need to be in such..

Calling Sub Packages.... - Hi, I am trying to call a sub DTS package from the main DTS package. When i trying to call, i am getting the following error. Step 'DTSStep_DTSActiveScriptTask_1' already exists in the collection. Please let me know what the issue is? ...
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]