SSIS package question
-
Hi, This is my first attempt creating a SSIS package. I am trying to imnport an excel spreadsheet into sql server table. I am running BIDS, sql server 2008. I specify an excel spreadsheet which is 2010 saved format, meaning a xlsx format. It keeps coming back with missing provider microsoft.ace.oledb.12.0 I have a 64 bit machine laptop from which I am creating this package. Do I still need to install the above? Thanks!!
-
Hi, This is my first attempt creating a SSIS package. I am trying to imnport an excel spreadsheet into sql server table. I am running BIDS, sql server 2008. I specify an excel spreadsheet which is 2010 saved format, meaning a xlsx format. It keeps coming back with missing provider microsoft.ace.oledb.12.0 I have a 64 bit machine laptop from which I am creating this package. Do I still need to install the above? Thanks!!
I think - 2008 uses the Access
Never underestimate the power of human stupidity RAH
-
Hi, This is my first attempt creating a SSIS package. I am trying to imnport an excel spreadsheet into sql server table. I am running BIDS, sql server 2008. I specify an excel spreadsheet which is 2010 saved format, meaning a xlsx format. It keeps coming back with missing provider microsoft.ace.oledb.12.0 I have a 64 bit machine laptop from which I am creating this package. Do I still need to install the above? Thanks!!
-
Thank you very much. I found this excellent article that help solve my problem. http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine[^]