Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2009-04-29 : 14:41:31
|
| SQL2000/DTS package Question:Hi:How can i use the following query in "Transformation_Task" of a DTS package to extract records, such that table_1 is on Database1 and table_2 is on Database2. Source is a UDL file pointing to DB1.Select A.Firstname,B.Address1from database1.dbo.table_1 as A, database2.dbo.table_2 as B Where A.CustID = b.CustIDAny kind of suggestions would be appreciated.thanks,RNothing much that i can do..!! |
|
|
|
|
|
How to use the following query /scenario in DTS?