Delete or Update SQL Task in BIDS
I have a SQL Task that I started out as a select to make sure I had all the multi-part identifiers set correctly, then I modified the sql to be a delete query, but I continue to get "The
multi-part identifier <field>" could not be bound." I have an input file from another database that I join on 1 field to delete the entries from the master. Very Simple. But I cannot do anything to get
around this error.
SQLServer 2005 Result Set = None Connection Type = Ole DB The field name on the Master is "Incident_ID" and on the input file the field is "Incident"
Delete ITAM_REP.tbl_MPR_Master Where ITAM_REP.tbl_MPR_Master.Incident_ID = ITAM_REP.tmp_MPR_Master.Incident
December 22nd, 2010 2:30pm
You likely need to include a FROM clause with a JOIN to reference the tables. Something similar to this:
DELETE FROM ITAM_REP.tbl_MPR_Master INNER JOIN ITAM_REP.tmp_MPR_Master ON ITAM_REP.tbl_MPR_Master.Incident_ID = ITAM_REP.tmp_MPR_Master.Incident
Free Windows Admin Tool Kit Click here and download it now
December 22nd, 2010 3:30pm
I have a SQL Task that I started out as a select to make sure I had all the multi-part identifiers set correctly, then I modified the sql to be a delete query, but I continue to get "The
multi-part identifier <field>" could not be bound." I have an input file from another database that I join on 1 field to delete the entries from the master. Very Simple. But I cannot do anything to get
around this error.
SQLServer 2005 Result Set = None Connection Type = Ole DB The field name on the Master is "Incident_ID" and on the input file the field is "Incident"
Delete ITAM_REP.tbl_MPR_Master Where ITAM_REP.tbl_MPR_Master.Incident_ID = ITAM_REP.tmp_MPR_Master.Incident
check your query in SSMS first.. did you check Joshua's solution..
let us know your observation..
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
December 27th, 2010 6:13am