Hi, Thanks for the information. I tried it by placing my longest data in the second row. Even then i am not able to set the datatype of external columns...

Hi,

I tried to do that. The datatype of External column is always getting reset to its original one. I am able to change only the datatype of Output column. Please...

Hi, Thanks for your reply. Please explain how to do that..

Hi, thanks for your reply.

I got this resolved by including the below two dlls in reference.

Microsoft.SQLServer.DTSRuntimeWrap.dll

Microsoft.SQLServer.ManagedDTS.dll

Hi, thanks for your reply.

We have around 6 db environments.

The automated backup or restore will not be necessary as we will not need the production data in all environments...