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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics