Exporting with mssql dts to mysql with date parameters

Posted on 2009-04-22
Last Modified: 2012-05-06
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?
Question by:krv123
    LVL 32

    Accepted Solution

    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.

    FROM MyTable mt
    WHERE mt.FieldWithDate >= Cast(Convert(varchar(10), GetDate(), 101) as Datetime)  -- your date cutoff values here
    LVL 26

    Assisted Solution

    by:Chris Luttrell
    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

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now