Update Table with SSIS out of a flat file

• guenther.lackner

  Old Hand

  Points: 356

  More actions

  December 3, 2008 at 9:04 am

  #194706

  Hi!

  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:

  UPDATE Assets

  SET AssetID=?, SystemID=?, [CO-Nr]=?, [IBA-Nr]=?, [AC-Location-Key]=?, LocationString=?, Model=?, KVA=?, Status=?, [Delete-Flag]=?, SerialNo=?, InventoryNo=?, Vorfall=?l, WertAlt=?, WertNeu=?, ChangeDate=?

  WHERE [LineNo]=?

  PLEASE HELP ME!!!!!!!

  best regards

  lacky

• dmc-608719

  SSCarpal Tunnel

  Points: 4663

  More actions

  December 8, 2008 at 9:44 am

  #909232

  Need some more information about the error your getting to be able to assist. But check this link for information on using it...

  http://msdn.microsoft.com/en-us/library/ms141773(SQL.90).aspx