Post reply

Can SSIS import a CSV and update a table all in one Data Flow process?

  • December 23, 2011 at 10:54 am

    #1425239

    Capt. Sigerson (12/23/2011)

    If anybody's still listening, I've run into a small wall in SSIS. I get a quote-delimited CSV file that I want to upload to a SQL Server temp table.

    I'm using a Flat File Source and a SQL Server Destination, but I'd like to convert three of the columns from numeric strings into integers before they go into the database. Is there an object I can insert in the data flow stream to do that?

    Yes, you can use a "Data Conversion" task.

  • December 29, 2011 at 5:22 am

    #1426388

    Hi,

    I would suggest to go for a temp table.

    Create a temp table. Store teh source data in your temp table.

    After this there are two approaches-

    Approach1:-

    After the dataflow task, use the Execute SQL task and write the update query.

    Approach 2: If the source data is not huge , you can go for an SCD task in the next data flow task to update your record based on your Business keys.

    Regards,

    Chandrashekhar

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

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