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 |
|
RichardSteele
Posting Yak Master
160 Posts |
 Posted - 2003-06-05 : 19:38:26
|
| When I try a DTS export using a query, SQL2k inserts the records into a Results table. Is it possible to use that query to insert records directly into an existing database table? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-05 : 19:48:38
|
| Sure, as long as the query matches the structure of the destination table (or you alter the column mappings to make it fit the destination) |
 |
|
|
RichardSteele
Posting Yak Master
160 Posts |
Posted - 2003-06-05 : 20:18:50
|
| When I choose the database table (with identical structure) my choice does not 'stick' and it inserts records to a results table anyway. What am I doing wrong? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-05 : 20:50:10
|
| I don't know, I've never seen that happen before. When you change the destination, the column transformations become invalid and need to be re-mapped (unless you're doing funky ActiveX tranformations I believe, I've never done them myself so I don't know how they behave) I'd suggest making the change again and then running the DTS package immediately, before saving the changes, and check the table to see if the insert occurred. |
|
|
|
|
|
|
DTS export using Query