DTS Package, global variable, test vs live?

Are global variable parameters in a DTS package specific to "only" that one package and do not effect other packages?

I need to add a variable to a test package but am worried that if I add this parameter it might affect the live production Table. There are two different servers on different sides of the firewall, there are two different databases and there are two tables but with different names, and there are DTS packages but they reference different tables in the query code.

So is it ok to add the global variable which would allow this DTS to delete recent records from the "test" version and it wont do anything to my live version?By the way I did check Microsoft's website for more details on DTS and variables. It looks as thought they're saying it is specific to only that dts, table and database. But it would be nice to confirm this with someone out there more experienced.

http://msdn2.microsoft.com/en-us/library/aa933470(SQL.80).aspxsqlsql

DTS package behaviour when used by > 1 User?

Hi all

I have a DTS package that users of the database can run which basically acts like a 'live update' (as the database is based on a values produced from another system) and it takes roughly 30 or so seconds to run...

The dts package is not going to have a particularly large hit rate but i am interested in knowing what will happen if a user (user 1) attempts to run the package when it is in already in use by another user (user 2) ?

Will User 1 simply have to wait untill the package completes for User 1?

OR

Will a new seperate 'instance' of the package be used by User 1?

Any info would be very helpful

CheersYou will have problems
the second DTS will start before the first stop

(maybe it's not problem it depends what they do)|||That was the answer i was hoping for really.

Basically this shouldn't be a problem for my scenario. The Users of the System are accountants scattered at various locations around the country and each of them Updates the their own locations data (via the dts package)and so this will not conflict with any other user updating the DB as it is a different locations data.

I was worried that if the user had to wait for the dts package to finish then i may occasionally have timeout issues (not that i haven't got a backup for this).

Thanks for your help, mucho appreciated.

DTS Import

I have a development database and a live database. I want to do a DTS
export from the live box to the dev box to sync the databases up. The
problem is that the development database has tables, stored procedures
associated to applications that aren't live yet because they are still
be tested or aren't done being programmed. If I do the import will
these tables get deleted or will they remain untouched?
Thanks in advance
Hi
Usually you would re-sync the data by scripting the changes from the base
version or (more prefereble) scripting the objects and keeping them in
version control, you can then use an upgrade script on the current version
to bring it into line with the development system.
Tools that may do this include SQL Compare from Red Gate www.red-gate.com
DBGhost www.innovartis.co.uk/Home.aspx and possibly Quest Central for SQL
Server
http://www.quest.com/quest_central/sql_server/freeware/
John
<anthony@.alocovare.com> wrote in message
news:1103136787.823604.21180@.z14g2000cwz.googlegro ups.com...
>I have a development database and a live database. I want to do a DTS
> export from the live box to the dev box to sync the databases up. The
> problem is that the development database has tables, stored procedures
> associated to applications that aren't live yet because they are still
> be tested or aren't done being programmed. If I do the import will
> these tables get deleted or will they remain untouched?
> Thanks in advance
>

DTS Import

I have a development database and a live database. I want to do a DTS
export from the live box to the dev box to sync the databases up. The
problem is that the development database has tables, stored procedures
associated to applications that aren't live yet because they are still
be tested or aren't done being programmed. If I do the import will
these tables get deleted or will they remain untouched?
Thanks in advanceHi
Usually you would re-sync the data by scripting the changes from the base
version or (more prefereble) scripting the objects and keeping them in
version control, you can then use an upgrade script on the current version
to bring it into line with the development system.
Tools that may do this include SQL Compare from Red Gate www.red-gate.com
DBGhost www.innovartis.co.uk/Home.aspx and possibly Quest Central® for SQL
Server
http://www.quest.com/quest_central/sql_server/freeware/
John
<anthony@.alocovare.com> wrote in message
news:1103136787.823604.21180@.z14g2000cwz.googlegroups.com...
>I have a development database and a live database. I want to do a DTS
> export from the live box to the dev box to sync the databases up. The
> problem is that the development database has tables, stored procedures
> associated to applications that aren't live yet because they are still
> be tested or aren't done being programmed. If I do the import will
> these tables get deleted or will they remain untouched?
> Thanks in advance
>

DTS Global Variables Behaviour with > 1 User

Hi all

I have a DTS package that users of the database can run which basically acts like a 'live update' (as the database is based on a values produced from another system) and it takes roughly 30 or so seconds to run...

The dts package is not going to have a particularly large hit rate but i am interested in knowing what will happen if a user (user 1) attempts to run the package when it is in already in use by another user (user 2) ?

The dts package is from a sp using the dtsrun utility (passes in global variables).

I know that a second DTS will start before the first has finished but what i am not sure about is what will happen to the Global Variables when the second DTS package starts - i.e. will starting a second instance of the package with different variables have an effect on the first DTS's global variables while it is running?

I hope the answer is "No Tom, it work fine!"DTS is a weird beast to describe, because there are so many different contexts. The short answer is that each of the instances of a DTS package will have their own global variables.

-PatP|||Pat

Thanks for the help. I really appreciate it.