Update File with only new records

[Cpreston]

HI

I want to be able to export from SQL a group of data into a CSV or Excel file. This is not problem at all and I can achieve this, however, I only want to update the rows for the text file or excel document if the import rows are new and not already in the file. Is this possible and if so could someone point me in the right direction. I have googled it but cannot find anything to assists.

The idea is we run the script several time a day and it should only update with new rows.

Thanks in advance

 

[fredericofonseca]

not possible to do in SSIS (at least with your limited C# knowledge).
but you can load your CSV file onto SQL Server, compare to the other data you are processing, and generate new file.

same goes for Excel.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886