I have a scheduled DTS Package that will run every night.
It will export a table from mssql and convert specified columns for my sql.
My dilemma is that the table is 700mb.
There is a column within the table that holds a invoice_date. Is there any way to specify in the dts export to export rows after a certain date?
What would be a better solution?