I sent my recommendations yesterday so lets see. Hopefully they will accept it.

Also I was thinking of writing a C# script which will dynamically create a tmp table based...

Hi Phil Parkin Thanks for Ur response , I was also thinking something like this , but how will naming convention help me ?

lets suppose if I...

i think this is a case of error handling please setup error output you will see why its failing.

i tired using your example and it worked for me , By Merge Join(inner Join ) i get the same result you get using the T-SQL.

In Derived Column Transformation try using:

(DT_STR,10,1252)[Columnname]