Hello, My requirement is to pull data from a SQL Server table and insert into an XML File using Web service. I could do it by using Script Task alongwith Execute SQL. But now I want to implement this using Web Service. I referred the following link - http://www.codeproject.com/KB/miscctrl/HttpEP_WST_SSIS.aspx?display=Mobile but I am getting an error : The error is: The request failed with HTTP status 401: Unauthorized.. Kindly suggest. Thanks in advance.Regards, Sonal

1) This is more or less related to web service access issue : Please check this : http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/fe5d1c0d-ddb1-4e10-b0cd-1fa7844a373b. Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!