Thanks for the info. I want to one more time explain the problem just to make sure that the statement u mentioned is write. So I have a source flat file which is in .csv format and it dumping the in data to a SQL table destination.
From the .csv file there are some columns and in the first column there is some data which is pulling AB12132123 and some data are coming as
NOT SPECIFIED 50B786EF-CBD4-4E29-A0A4-3DAB32F3F334.
the second value is not supposed to be coming in and should be ignore/skip from the source file. So the statement u mentioned is right? and if it is Do I have to write an update statement on a destination table?
Also, for SSIS in the derived column how should I write in the Expression.
The Source and destination Column Name is ROW_ID.