October 14, 2014 at 2:54 pm
I have a package that creates and excel file and dumps some data in, and then renames the worksheet to the current date using a script task at the end. In order to do so i had to use the microsoft.office.interop.dll. The package works just fine locally but fails with the following error when published. I installed Office 2013 on the server hoping it would cure my problem but it didnt ?
"Update worksheet name: Error: Exception has been thrown by the target of "
October 15, 2014 at 12:27 am
coreyjbaum (10/14/2014)
I have a package that creates and excel file and dumps some data in, and then renames the worksheet to the current date using a script task at the end. In order to do so i had to use the microsoft.office.interop.dll. The package works just fine locally but fails with the following error when published. I installed Office 2013 on the server hoping it would cure my problem but it didnt ?"Update worksheet name: Error: Exception has been thrown by the target of "
Are you sure that there isn't a bit more to that error message?
The package may be running in 32-bit mode locally (if you are using SSDT) and 64-bit mode on the server (if you are using SQL Agent to run it). You may like to try running it in 32-bit mode on the server too, in case that helps.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply