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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-28 : 07:35:56
|
| Jon writes "I'm new sql server and currently practicing with DTS. What I want to do is have two text fields, one containing names and addresses and a primary key number, and another text file containing a primary key number and a phone number ..what i want to do is add all the items from the first text file to a database that i have created using a transform data task (which i have already done) but now i want to add the phone numbers from the second text file to the database where the primary key value in the second text file matches the primary key value in the database.i have been told to do this using Lookup.. but i dont know where to start or what is required...can anyone PLEASE helpthanks in advance" |
|
|
|
|
|
Using DTSLookup to match values from source text file and destination database