Thanks Amit,

Yes i got the problem. xp_cmdshel runs in server and i don't have excel in server. SO i think i should not use Excel automation in my DTS since...

Thanks Ahren,

I am not using a trusted connection. QA is logged with the same userID (the package owner is logged in)

I am passing the user ID & password as parameter...

Thanks,

Do you mean to, write a Vb script and connect using ADO and explicitly write into excell file?

I tried creating a Activex Script for transfomrations. Did the column to column...