I have a flatFile which has 3 columns. Serialnumber,name,string.
And i have a DB Table called dbo.devices and i have two columns in it deviceID,Serialnumber.
In this table for each serialnumber ,deviceid is a identity generated column.
Now i want to replace the SerialNumber Column in the FlatFile with the Correspoding deviceID column in the DB Table.
My flat files will have app 20ooo Rows and i have 7000 Files.
How can i accomplish this Task. This is just a one time task but i want it to be done in faster way.
Am planning to use a Lookup Transformation For this
View Complete Post