• There is an excellent software that can convert DTS packages to SSIS packages from a company called pragmatic works. I have done this recently and it works. I had to do some code adjustments (cast and stuff) on one column only. Otherwise it worked superbly.

    So now I do not have to worry about DTS packages anymore as they are depreceated by Microsoft.