I use Netsuite as our CRM and have access to their WSDL web service at? <[url removed, login to view]>
The objective here is to allow me to keep data between my local SQL 2005 database and Netsuite Hosted CRM in synch with customer and accounting (Invoices/Payments etc) information.
I am trying to use Microsoft BIDS and Integration Services to create a Web Task that will allow me to upload information direct into Netsuite from my local SQL 2005 database server.
I have followed instructions described in this link? <[url removed, login to view]>? but each time I select Input from within the Web Task component in BIDS I get an error saying:-
"Item has already been added. Key in dictionary: 'StatusDetailType'? Key being added: 'StatusDetailType'"
I am looking for someone to both solve the above error and write either some T-SQL or use Integration Service so that I can push data from SQL 2005 server into the Netsuite CRM using the web service.
This will allow me to keep both Netsuite and local Database in synch
Thanks for any help