Cannot import multiple xlsx files using foreach loop
I can import any file when I use the the excel connection manager pointing directly to a file. As soon as I utilize a variable and change the connection string on the excel connection manager it fails. Here is what I am changing the connection string to "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @[User::CarePacksImport] + ";Extended Properties=\"Excel 12.0;HDR=YES\";" Getting Property value not valid Exception from HRESULT: 0xC0024108 As soon as I leave field.
May 3rd, 2012 5:01pm

What is in @[User::CarePacksImport] ?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2012 5:18pm

Hi There What version of SSIS you are using are you using SSIS 2008 Are you getting the path of your excel files inside @[User::CarePacksImport] Please update Many thanks Syed
May 3rd, 2012 11:05pm

Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2012 11:29pm

May 4th, 2012 6:23am

Using 2008 SSIS. Yes @[User::CarePackImport] is the path to the excel files. Thanks Syed I will try that and let you know
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2012 8:48am

Thanks Syed that was my issue. Just had to recreate the excel connection manager
May 4th, 2012 9:35am

YOu are connecting to a EXECL12.0 with a Excel source connection within SSIS please check this Link you will see the diference between Excel12 and 8 Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2012 9:52am

Hi There I hope this will resolve your problem if it resolve your problem Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful Many thanks Syed Qazafi Anjum
May 4th, 2012 11:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics