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 |
|
jonaskarlsson
Starting Member
2 Posts |
 Posted - 2005-06-02 : 10:12:38
|
| Hello,I have no problem importing a whole text file using DTS Transform Data Task.But, what if I only want to import selected rows from the text file. E.g. rows with an id that already exist in a current table in the data base? How do I do that? For each row in text file I need to lookup a corresponding value in the db...?Thanks!/Jonas Karlsson |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-02 : 10:14:05
|
| I usually bring in everything to a staging table, then use SQL to choose what I want in the final destination. It's so much less messing around doing it that way. Much easier to test and troubleshoot too.DamianIta erat quando hic adveni. |
 |
|
|
Chris Orlando
Starting Member
9 Posts |
Posted - 2005-06-02 : 16:37:27
|
| I just realized I posted the same question. If I hear anything, I will let you know. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-02 : 19:14:39
|
Heh, you got the same answer there as is in this thread.... but what would we know  DamianIta erat quando hic adveni. |
|
|
|
|
|
|
Import only selected rows from text file?