Running 2000
DTS sounds good but i have never used it before, i've created a package, created both connections, do i now need to use 'Transform Data Task' ?
If so, i write click on the arrow, choose properties then it brings up the properties, click on the transform tab and it looks like i can...