Migrating DTS packages on instances

I have problem and don't know how to resolve it.

I'm running multiple instances(developpement,acceptation, production) on one server with the same db's on each one of them.

Now I'm trying to find out a way to transfer DTS packages from one instance to another (I know it is straight-forward if you don't have to change anything) but in my case I would want to change the connection properties within the dts package e.g.

on my server\developpement instance I've created a DTS package with connection properties server name server\developpement

Now I want to transfer it to my server\acceptation instance and there I want the connection properties server name to be server\acceptation .

I've tried doing it with a dynamic properties task but I can't seem to find the instance name where the package is saved. I can only find the server name(environment variable).

This of course is no problem if you have but a few packages, but if you have over 50 to transfer

Any help would be more than welcome.

Rosko

PS: I know it is possible between two different servers using (local) as the servername but that's not an option for my boss.I have a very similar situation. I currently have global variables. When I migrate, I am changing this from Package Properties.

If I do not find a solution, I plan to have a flat file and read the information from that file using ActiveScript.

Please let me know if you have a better solution.|||See

"LoadFromSQLServer' & 'SaveToSQLServer'
in SQLServer Books online or on the web.
this can be called in VB and will repopulate on the other server.

For more advanced changes the attached structe can be populated and manipulated in VB to create new DTS Packages.|||Correct me if I am wrong. I think this still does not address the issue.

The issue is to set the datasource property to the connections within the package(s) while the package is migrated from one instance to another.

LoadFromSQLServer and SaveToSQLServer seem to help in migrating from one instance to another.|||Unfortunately jayaramanc,

The connections held in the connections object must also be updated with the new server name, as does any ADODB connections in ActiveXScript in the Steps object.

Microsoft Visual Studio

I am using Microsoft Visual studio and have a question. I need to put
multiple tables on the same report how can I do that? I got this reply to a
previous message but dont understand it
"Depending on your needs, you can either create a dataset that is based
on a query/stored procedure that accesses both tables -or- create 2
separate datasets, each going to a different table and have them
populate different report controls (i.e., table/matrix controls). Hope
this helps."
Can someone please take me through this step by step in detail?On Jul 1, 12:12 am, SQL Server express edition 2005
<SQLServerexpressedition2...@.discussions.microsoft.com> wrote:
> I am using Microsoft Visual studio and have a question. I need to put
> multiple tables on the same report how can I do that? I got this reply to a
> previous message but dont understand it
> "Depending on your needs, you can either create a dataset that is based
> on a query/stored procedure that accesses both tables -or- create 2
> separate datasets, each going to a different table and have them
> populate different report controls (i.e., table/matrix controls). Hope
> this helps."
> Can someone please take me through this step by step in detail?
If you are wanting to combine multiple database tables in a report,
you can write a stored procedure/query including something like this:
select a.*, b.*
from table_a as a
inner join table_b as b on a.x = b.x
Then in the Report in the data view, to the right of Dataset: select
<New Dataset...> and then enter the stored procedure name as the query
string and select Stored Procedure as the command type. Then in the
Layout view, drag-and-drop a table control from the toolbox (Ctrl+Alt
+X). Right click the table control and select Properties. Then on the
General tab, select the dataset you just created below Dataset name:.
Select your header and footer rows via right-clicking the Header/
Footer row and selecting Properties. In the General tab select the
Value (Field from the dataset) you would like to display. If you just
want to display text, instead of right-clicking and selecting
Properties, right-click and select 'Expression...' and enter in
something like: ="Some text here." Do the same for the detail row.
If you want 2 table controls from different database tables, do the
same as above but create your dataset based on a single table or query
of your choice and then repeat for the number of different database
tables or queries you want to use. Just drag-and-dro the number of
different table controls you want to use in the report and repeat the
above steps. I hope this clarifies it a little better for you.
Regards,
Enrique Martinez
Sr. Software Consultant