Check the DTS package properties such as SOURCE and DESTINATION SQL Server names, try to connect the same from Query Analyzer and OSQL too.
I believe the problem seems to be the connectivity with the name specified in the dts package.