ok Phil first off, thank you thank you... for taking the time... i found the problem... and yes i am going to take myself out back and beat myself over...

ya no problem:

Data Source=C:\test\Test_Import.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="EXCEL 12.0";

that is what I have.

gotya, sadly still didn't work, still same error message, attached the screen shot 🙁

I rebooted my laptop to make sure the excel file that is on my C drive, and...

k, i just installed first Access office 2016 64 bit driver, then the office access 2010 32 bit. just need your thoughts and wondering. since i installed the drivers, should...

gotya thanks for the info, i will go ahead and do those steps now. see if that fixes the problem.

Hey Phil, thank you again for the questions, sorry, so I am deploying to my local instance on my laptop, which does have admin rights for the user Steven (which...

k I believe I am getting close, different error messages now, I uninstalled the Office Access 2010, and re-installed it... rebooted, and made sure it was 32 bit... now I...

Sorry I thought I replicated the issue on SSIS visual studio, but after I closed it and re-opened it... not sure why but works fine.... tried restarting the SQL engine...

Hello,

so an update, not sure if this is any better. but what I decided to do, is go through SSMS, create a import process, so it will create the excel...

Hey Phil, thanks for the info, ok so on the properites of the foreach loop, when i go to collection, on the foreach loop editor, where it says Enumerator, i...

• This reply was modified 5 years, 4 months ago by Siten0308.

Hey Phil, good thought, I was just thinking that and checked, plus added my account that will run the SQL agent service and sql job/ssis package... unfortunately, still the same...

awesome thanks everyone

Cool thanks for the input John, not saying you are wrong, but is there a Microsoft Article or reference i can look at? i have been trying to find one...

great thank you Jeff for the additional input. that makes sense. The App team will use that account for all app to interact from app server to database. thanks again.

Hey Jeff,

sadly not my choice, but they are deploying an application, and the application is requesting to create some schemas, so, I hoped they would give me the scripts for...