Thanks for the Article Its just what I am looking for .

I cant get it to work though,I think its something to do with the variables .

And explicitly setting them from currency to string,I just dont have a clue how to do that though .

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object..

at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)

at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)

at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".