rhythm.varshney (11/12/2012)
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 ??
Yes. The SSIS expression language is going to be much easier to do this in. And while it is a bit of a paradigm shift, get away from the staging table idea. We want to be doing ETL (Extract, Tranform, Load) rather than ELT (Extract, Load, Transform). SSIS excels at doing these things in memory, in the pipeline. Writing to staging table(s) in the interim slows things down considerably. When things get overly complex for a single dataflow, I will often write to raw files for the interim step rather than a db table ... still much faster.