• Where I am working, a consultant used the migration wizard for dts->ssis and it has seemed to work well.  You cannot use ActiveX scripts, they must be converted to .net Script tasks, but there is additional functionality in ssis and you may not need them any more.  There was a glitch though, dts package names cannot have spaces in them or the wizard will hang up before it shows a list of migrate-able packages.