Hello, This is a difficult problem to explain. I am trying to use SSIS to grab database items and upload them into a SharePoint List (using the sharepoint web service). When an item is created in the list, i have a workflow set to update a column in the list. When I run this SSIS package from Visual Studio 2005 on ServerA, it works fine. Items are uploaded, workflow is run, list item is correct. When I deploy the package and create a SQL Job on ServerA, it does not work 100% correct. In fact I have had 2 problems with this package. (1) The package used to fail with a similar error found here: http://support.microsoft.com/kb/918091/en-us. I was never able to find the patch for SP2. The download from this article said it only works for SP1. (2)I removed some code from the package that stopped the error above from happening. Now, the package looks like it executes successfully. The list items are uploaded into the SharePoint list, but the workflow is not started. Something must be wrong w/ SQL Server or my SSIS package. Has anyone come across either of the problems above? Thanks,Dana

When running from the Agent job, try using a CmdExec step type, and call DTEXEC to run the package. I'm not sure if that will make a difference in your situation, but it has cleared up a similar problem for me in the past. Also, guessing that you are already on SP2, but if not, make sure you upgrade.

THANK YOU! Yes, this indeed worked. By running it via command line, the package executed perfectly and the workflow started as expected. dana

Hello I am also looking for same process, but something different in my case I want to send mail to sharepoint group whenever file is uploaded. I am new to SSIS, any good article on this or if it is not against your ethics can you tell me the steps. Ashish

You can use the Send Mail task from SSIS to send an email. To email a Sharepoint list, you need to set up the list to have an email address. Then just configure the Send Mail task to that email.

jwelch - I hope you are still online. I am not sure I quite understand this step. I have a remote machine which i build the SSIS package and it connects fine the Sharepoint server but when I deploy it to a SQL server I get the error. Do I have to install the sharepoint adaptors on the SQL server as well? Also, Can you get a brief example of how to write the command for the CMDExec with the DTEXEC..say for a job titled JOB? Thanks.