-
Importing A Text File Using The DTS Wizard
Hi people! I have to import several text files to a certain table in MS SQLSErver 2000. I decided to create a DTS Package. I have a text file (source), a connection and a transformation task. I just selected wich "columns" from file belong to wich columns in table and i executed it. The problem is I have some records repeated in file and it affects the primary key in table. How could i know that record had already been "copied"? I know how to skip an insert (ActiveX Scripting) bnut i dont know how to find the repeated records in file.
Sorry my english and thanks in advance!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|