Hi all, Has anyone tried using DBAmp with SQL Server 2005 Integration Services? It seems to be fine as a source but I can't get it to work as an OLE DB destination. I can call up the list of tables and select one but when I try to access the "Mappings" dialog I get this error:

Error at Package [Connection manager SALESFORCE.user.name@org.com]:

An OLE DB error has occurred. Error code: 0x80040E22. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E22 Description: "Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.".

Error at data flow [OLE DB Destination [490]]: The AcquireConnection method call to the connection manager "SALESFORCE.user.name@org.com" failed with error code 0xC0202009.

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

I think I'll look to get round this by encapsulating the updates/creates in stored procedures but I wondered if anyone else had come across the issue.

Thanks,

Andrew