Post reply

sql 2005 ssis Import Multiple xlsx files

  • June 10, 2009 at 8:09 am

    #95590

    Hello,

    I need to import multiple XLSX files into SQL SERVER using SSIS FOR EACH CONTAINER AND OLE DB SOURCE.

    i.e all files Excel 2007 files in a folder. ( they are all the same format)

    I can do this fine using the for each file container with xls (2003) files and using and expression to swap out the data source with a file name variable but I'm unable to do so with XLSX files.

    I can see how you can import single XLSX files via the OLE DB provider instead of the Excel connection Manager but I can't seem to get the expression technique working for OLE DB provider to change to the next file.

    I can do this using TSQL but I wanted to do it all in SSIS! Like I have done with 2003 files.

    Has anyone does this and can provide me with a step by step guide for importing multiple excel 2007 files from a folder into a sql db Using SSIS 2005.

    Many thanks

    Phil

    :crying:

  • June 16, 2009 at 1:38 am

    #1010058

    ignore

  • June 16, 2009 at 3:05 am

    #1010071

    ignore ?

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

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