Hi, It work like a Champ.

Thanks.

Thanks for giving me hints and your oppinions.

Actually I was trying to Migrate data from ASA to SQL server. I though I need to export out all tables then do...

I can change source and destination parameter. And I can make loop to execute dts but how to change the Transformation during run time. each time it run the source...

I can't use bcp or bulk insert. I faced the problem since some record of the table has the column with control character.

DTS can solve my problem but I need...

get it wrong. But get more knowledge. Thanks.

We are talking faster here. how fast is it?

if the different only 1/100 second then what does it make different for the user?

as a developer it will be easier to write withour...