RE: Is it possible (version 7 SP3) to use a SQL query object in DTS that ,references tables in two different database connections?

RE: Is it possible (version 7 SP3) to use a SQL query object in DTS that ,references tables in two different database connections?

 

  

Create a temporary staging table in your destination database. Pull
that data into the staging table, and then reference that table and the
other table for further transformations/work/comparison.


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


-----Original Message-----
From: Quentin Preik
[mailto:mssqldba-ezmlmshield-x42376323.[Email address protected]
Sent: Wednesday, March 30, 2005 1:35 PM
To: LazyDBA Discussion
Subject: Is it possible (version 7 SP3) to use a SQL query object in DTS
that ,references tables in two different database connections?

Is it possible (version 7 SP3) to use a SQL query object in DTS that
references tables in two different database connections? If not is
there a way around this limitation?




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