I am using SQL Creator to query a table in SQL Server. This table has about 45M records.
My VPN only stays connected for 24 hours, and my workspace needs more time to run.
Last night, I was up to 27M records written to text. In lieu of starting over, I was hoping there is a way to run the workspace again, but exclude the 27M records already written. There is a unique field in the table, so it would just be a matter of excluding based on that one field. I cannot figure out how to do this. I do have a list of the unique IDs that were already written in a MS Access database table.
Is there a transformer that would allow me to do this?
Thanks!
Erin
