SSIS - basic question

  • The users also need to see what data was there in the file and what was matched through a web application and then reports are run off of that data so thus dumping to the DB

  • OIC - that makes some sense then.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Ok, 2 data-flows, first one imports the CSV to DB, second one takes the DB to CSV. probably an EXEC SQL task to clear the DB table and voila..

    CEWII

  • Thank you all for the time you guys have given to help me out! Much appreciated.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply