In SQL 2005 Edit the step and make sure on Data Sources tab that the value of your provider in the connection string of your Destination Connection OLEDB is correct.

Data Source=23423423423423;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=false;

NOT:

Data Source=23423423423423T;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=false;