EXCEL ISSUE IN SSIS
I have created One ssis package in vss 2008. after i had deployed on UAT server. it was failed because in uat server excel is not installed. Can you tell me which flug in i will install in server.
August 2nd, 2012 6:07am

You have to install Microsoft.Jet.OLEDB.4.0
Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2012 6:16am

What is the exact error? Normally Excel itself doesn't need to be installed on the server, the OLE DB providers on the other hand do. Microsoft.ACE.OLEDB.12.0 for Excel 2007 and up. Microsoft.Jet.OLEDB.4.0 for Excel 2003.MCTS, MCITP - Please mark posts as answered where appropriate.
August 2nd, 2012 7:03am

First of all what is the error ? second, you are using excel you you should be calling it with DTExec 32bit not 64. so the question is how are you calling your package? Sincerely Nik -- 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
August 2nd, 2012 10:27am

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

Other recent topics Other recent topics