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
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