I created a few DTS packages in our Test Server saving them as file.dts. When I try to open them in from the production server I get an Unexpected error and the DTS is not opened. Do you have any fresh idea for me, please? Thanks!!
DTS is finicky I've found. This could be because the MSSQL servers are different versions, but most likely different configurations. It's not recommended, but you can try copying the row in the system table that contains the dts package into the production system table.