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 |
|
roddy1212
Starting Member
4 Posts |
 Posted - 2005-06-28 : 13:23:41
|
| Hi,I have a Focus program that generates a text file with the last 15 days of data. I need to have the new day of data added to a SQL Table(which also has an primary key index). The File is created in a daily basis... A sample would be: Day 1: Records: 1, 2, 3 Day 2: Records: 2, 3 , 4 What I need my DTS package is to add only record 4 in day 2.But what it doing is rejecting every row, even when it is not dupplicated in the target table...Is there any trick to accomplish this without making any changes to the source program ?Roddy. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-06-29 : 01:54:17
|
| you can create a dumping table for every insert being made in your source table,at the end of the day, create the text file and truncate the tablefor dumping the data, you can incorporate this in your program or create a trigger on the source tableHTH--------------------keeping it simple... |
 |
|
|
roddy1212
Starting Member
4 Posts |
Posted - 2005-06-29 : 10:01:50
|
Jen,I appreciate your commennts...I created an Outer Join (between the Target and Source table) to extract only the new records from the Source table. Then I insertedthose records to the Target table. It is working great now...Thanks very...From now on, noone will be able to take out of this forums...They are really great !!!.. |
|
|
|
|
|
|
Error when trying to append new rows using DTS