I have a data flow task to do an update or insert depending on match or no match output from a lookup transformation in SSIS package.
I have an OLE DB Source -->to a Data Conversion --> to a Pivot --> to a Lookup and split
match output to OLE DB Command
no match output to OLE DB Destination
In the OLE DB Command I'm using an update query:
UPDATE TableName SET
Field1 = ?,
Field2 = ?,
Field4 = ?,
Field5 = ?,
Field6 = ?,
Field7 = ?,
Field8 = ?,
Field9 = ?,
Field10 = ?,
Field11 = ?,
Field12 = ?,
Field13 = ?
WHERE ((Field14 = ?) AND (Field15= ?));
But it doesn't seem to be getting the parameters because an error stating that there is more than one data source column with the name "?" and that the data source column names must be unique. I have my parameters set up in the lookup transformation editor and can see them when I click the "Parameters" button on the Advanced Custom query. I don't know what I'm doing wrong??
Any help would be greatly appreciated!