Why would you use an execute sql task instead of 2 database connections
(source and destination) and a transform data task between the two? You can
set "allow identity insert" in the options tab of the transformation...

-----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