Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Update Table with SSIS out of a flat file Expand / Collapse
Posted Wednesday, December 3, 2008 9:04 AM


Group: General Forum Members
Last Login: Friday, September 18, 2009 1:28 AM
Points: 14, Visits: 41

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=?
WHERE [LineNo]=?


best regards
Post #612934
Posted Monday, December 8, 2008 9:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 19, 2016 10:24 AM
Points: 383, Visits: 787
Need some more information about the error your getting to be able to assist. But check this link for information on using it...
Post #615640
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse