Post reply

insert data from excel file into table using SSIS

  • September 16, 2011 at 4:08 am

    #243286

    My excel file having many sheets

    I need to take data from 1st sheet but problem is that value is generated like SUM(A1:A12)

    now I'm not able to map this value in my SSIS package

    please help

  • September 16, 2011 at 4:23 am

    #1382454

    Is this a one time load? If so, just save this particular sheet as a .csv file and load the flat file into your SQL table using SSIS. Either way, the fact that it is a calculation shouldn't matter in the import.

    Rob

  • September 16, 2011 at 5:13 am

    #1382473

    hi ,

    my excel file having more than one sheets

    and

    I don't know how can i convert that file into csv.

    I don't know how can i do mapping in ssis I'm new please tell me

  • September 16, 2011 at 5:23 am

    #1382478

    In MS Excel, do a File, Save As, and choose the CSV (Comma delimited) (*.csv) choice. This will convert the particular sheet from .xls or .xlsx to a .csv file.

    In SSIS, add a Data Flow Task to your package. Inside the Data Flow Task, add a Flat File Source transformation. That should get you started.

    HTH,

    Rob

Viewing 4 posts - 1 through 3 (of 3 total)

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