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 |
|
rav_hi
Starting Member
4 Posts |
 Posted - 2004-10-26 : 13:16:52
|
| Hi All,I am using DTS to transfer my data using SQL Server Data Bases, I am having the same database schemas as source and destination. I am trying to do that using data driven query task option. In that How can I provide insert query in query tab. I am provided with the template query, I am provided with the columns to whic insertion is performed, Now How can I provide the values using query. I want to insert all the rows in source table to destination table.Thanks in advance.Parul |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-10-26 : 14:50:13
|
| Why are you using DTS?INSERT INTO DestinationTable (column1, column2, ...)SELECT column1, column2, ...FROM SourceTable- Jeff |
 |
|
|
|
|
|
How to select values to be inserted