Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, December 3, 2008 9:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 18, 2009 1:28 AM
Points: 14, Visits: 41
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
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: Wednesday, April 16, 2014 8:22 AM
Points: 375, Visits: 765
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
Post #615640
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse