Error while creating excel file on server where excel is not installed
hi experts,
my package works on local machine but doesnt work when I move to a server...
I get error at the execute sql task where I have the connection manager as "Excel" and I create an excel file with a tab and some headers, I have tried a solution that was suggested online to change the package properties to 64bit as false, I have tried that but it doesnt work either, please help:
[Execute SQL Task] Error: Failed to acquire connection "Create_genericExcel". Connection may not be configured correctly or you may not have the right permissions on this connection.
my package works on local machine but doesnt work when I move to a server...
I get error at the execute sql task where I have the connection manager as "Excel" and I create an excel file with a tab and some headers, I have tried a solution that was suggested online to change the package properties to 64bit as false, I have tried that but it doesnt work either, please help:
[Execute SQL Task] Error: Failed to acquire connection "Create_genericExcel". Connection may not be configured correctly or you may not have the right permissions on this connection.
Kevin Cross
sqlcurious, what are the values set behind the [Execute SQL Task] and what exactly is the SQL statement trying to do. As the error message implies, your local SQL instance may have certain features enabled that the server does not. In addition, locally you are executing as a sysadmin most likely whereas that may not be the case on the server. Further, if this is writing out a file to a path that does not exist or the server does not have permissions to via the account running SSIS then you may be getting the permissions error for valid reason.
what is your connection type? Excel or OLE DB?
try with OLE DB also and let us know the result
try with OLE DB also and let us know the result
ASKER
Hi Reza_rad the connection type is excel and I tried OLEDB, it works fine.
Hi MWVisa1 the execute sql task creates a excel file with a tab name and headers, thanks. And all the assumptions that you had regarding the errors is not true.
Thanks!
Hi MWVisa1 the execute sql task creates a excel file with a tab name and headers, thanks. And all the assumptions that you had regarding the errors is not true.
Thanks!
Hi Reza_rad the connection type is excel and I tried OLEDB, it works fine.so this means that your problem solved by OLEDB connection?
ASKER
No my problem is not solved, I will still need to create an excel file using execute sql task and excel as the connection
thanks
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks