Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Why my SSIS package can't create file in Document Library from SQL Agent Server

  Asked By: Cedrick    Date: Dec 23    Category: Sharepoint    Views: 2046

I have a SSIS package which runs under SQL Agent Server that need to create files into Document Liarbry. The SQL Agent Server runs the SSIS package with user which has full control on the Document Liarbry. But I am keep getting Access is Denied!



1 Answer Found

Answer #1    Answered By: Candi Branch     Answered On: Dec 23

I fixed it by myself, the answer is using "Script Task" with Sharepoint Web Service "Copy"!