I'm trying to execute the package PubMedDisambiguation_GetPubs.dtsx. The package breaks when trying to execute the task, "Store PMIDs" with the following error:
"[Execute SQL Task] Error: Executing the query "[Profile.Data].[Publication.Pubmed.AddPMIDs]" failed with the following error: "Unsupported data type on parameter binding @PMIDxml.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
Connection is fine and the sql parsed correctly. Anyone have any ideas on how to resolve this? Thanks in advance.