Post reply

Flat File to Update Rows in existing table

  • September 4, 2008 at 11:59 am

    #125165

    What is the easiest way to go from a Flat File to update rows in existing table.

    Can you use a flatfile source to a ole db destination with a sql command with the update right there?

    If so how do you query the flatfile source?

    Thanks,

    Ken

  • September 4, 2008 at 2:13 pm

    #867412

    try using Staging tables in your database. Get the data out of the flat file as fast as possible and into your database. Create a table that can be removed later to store the flat file data prior to updating the final table. Then you can use a not in or if T-SQL statement to see what needs to be updated based upon the staging table. Hope this makes sense.

Viewing 2 posts - 1 through 1 (of 1 total)

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