Sorry if this question souds stupid but I did not find a good tutorial for learning this basic in SSIS.
I have a flat file and I am importing the content into a table. Works perfekt! But I got a second flat file with data sets that have to be updated in my table. I am trying to use the "OLE DB Command" for this task.
But I dont know how to write the SQL statement correctly:
SET AssetID=?, SystemID=?, [CO-Nr]=?, [IBA-Nr]=?, [AC-Location-Key]=?, LocationString=?, Model=?, KVA=?, Status=?, [Delete-Flag]=?, SerialNo=?, InventoryNo=?, Vorfall=?l, WertAlt=?, WertNeu=?, ChangeDate=?
PLEASE HELP ME!!!!!!!