sql 2005 ssis Import Multiple xlsx files

• philokeeffe75

  SSC Veteran

  Points: 277

  More actions

  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:

• eharper

  SSC Eights!

  Points: 802

  More actions

  June 16, 2009 at 1:38 am

  #1010058

  ignore

• philokeeffe75

  SSC Veteran

  Points: 277

  More actions

  June 16, 2009 at 3:05 am

  #1010071

  ignore ?