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!
I fixed it by myself, the answer is using "Script Task" with Sharepoint Web Service "Copy"!