Exporting with mssql dts to mysql with date parameters

Experts,
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?
or
What would be a better solution?
Thanks.
LVL 1
krv123Asked:
Who is Participating?
 
Brendt HessSenior DBACommented:
Use a SQL Statement to generate your output, instead of a simple "Copy Table" process.  Your data source would be an SQL query with the appropriate WHERE clause, e.g.

SELECT
    Field1,
    Field2,
    .....
    FieldN
FROM MyTable mt
WHERE mt.FieldWithDate >= Cast(Convert(varchar(10), GetDate(), 101) as Datetime)  -- your date cutoff values here
0
 
Chris LuttrellSenior Database ArchitectCommented:
can you not add to the where clause to the sql in the DTS package to limit the resultset?  Maybe
Where/And ivoice_date > getdate()-7 -- last 7 days
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.