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 |
|
sixdeep357
Starting Member
2 Posts |
 Posted - 2008-04-03 : 13:12:48
|
| Hi. I'm new to DTS and I was hoping someone might be able to help me with an issue I'm having attempting to combine table1 and table2 into table3. My sql statement is as follows. It works if I run it as a query but if I try to put it in a DTS package I can only select one source table in the drop down window. Is there anyway to grab from multiple source tables and perform the query? ThanksINSTERT INTO table3SELECT A.name, A.account, A.sex, B.religionFROM table1 A INNER JOIN table2 B ON A.account = B.account |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-04 : 05:27:16
|
| Instead of selecting tables, you can write this query in Transform data source tab.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
DTS Combine two tables into a third table