What do you mean default values. If you changing tables and columns to
match according to the global variables you need dynamic properties
task. More information is needed to help on why the global variables
aren't setting the values you need.


Brian Freeman
Carnegie Technologies/Bluewave Computing
(770) 916-0595 ext. 415
www.carnegie.com
www.bluewave-computing.com


-----Original Message-----
From: Udi Yeger
[mailto:mssqldba-ezmlmshield-x98914719.[Email address protected]
Sent: Wednesday, March 30, 2005 4:28 PM
To: LazyDBA Discussion
Subject: DTS AND GLOBAL VARIABLES

I need to do the following:



Set identity insert on

Truncate table

Populate local server table with data from production server

Set identity insert off



I set up a dts package with global variables,execute sql task, transform
data task.



When I run dtsrunui and put in different values in for the global
variables transform source and target tables are not picked up. DTS
tries to use the default values.



I know this might now be enough information. If there any DTS experts
out there I would appreciate the help. I could send you the file.



Thanks



Udi Yeger

Subject Wills & Company







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page