Randy Knight (11/11/2012)
So you are importing the column to your staging table in it's native format and then splitting it from there? On what basis are you splitting it (i.e. at a certain column #, cerain character, etc.)? We need some more info to answer but in general I would think SSIS will be better at this kind of operation than T-SQL.
yes.I am importing the data to staging table as it is and there I am applying split on a column say name into first name and last name on the basis of space between two.
so you meant too say derived column would be better approach ??