Error in creating an excel file in a sharepoint site from ssis package

See more:

SQL

MS-Excel

SharePoint

server

, +

Hi,

I am receiving the below error while trying to create an excel file in a sharepoint site from ssis package.

Error Code: 0x8004005 Description: "Failure Creating File". Failed to acquire connection "Excel connection Manager". Connectin may not be configured correctly or you may not have the right permissions on this connection.

I have created a package for this. But it always fails to create a file in sharepoint site but works fine in local system.

Is there a way to create an excel file in sharepoint site from ssis without using script task from SQL?

Thanks
DhivyaJ