Yeap. Its very old version of sql server. Thanks for your inputs anyhow. I will continue to search for better way and will let you know if i found better...

Hi Jim,

Thanks for replying me. Sorry for the lack of details.

Its a dts job, retrieving data from source systems , transforming it and mapped into tables in the sql server....