Error while creating excel file on server where excel is not installed
Posted on 2011-10-05
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.