Hello all, i am a newbie and this is my first post.
Perhaps my problem is related.
When I execute a DTS 2000 as a legacy, it executes successfully.
When I migrate it, it appears under MSDB and with what I'd been reading, package migration also converts it into a new format in 2005.
When I execute it though, one task in the package fails, and the package run log says 'package or DB password encryption eror'. The DTS package task simply insert rows from an Excel spreadsheet after some basic transformation (column mappings). I also get prior warnings on truncation and varying column sizes.