help with error: 0xC0014062

• AIRWALKER-375999

  Hall of Fame

  Points: 3040

  More actions

  December 1, 2008 at 3:56 am

  #125244

  Hi,

  I'm trying to execute a dts package from command line using this code:

  DTExec /sq My_Package /ser My_Server

  but I keep getting the following error:

  Could not load package "My_Package" because of error 0xC0014062.

  Description: The LoadFromSQLServer method has encountered OLE DB error code 0x

  004005 (Login timeout expired). The SQL statement that was issued has failed.

  My server name and package names are correct, the dts package itself is saved to the sql server. Am I going wrong somewhere

  Thanks

• shmuel_v

  Old Hand

  Points: 354

  More actions

  December 1, 2008 at 4:18 am

  #905465

  Look at link :

  http://www.sqlservercentral.com/Forums/Topic455318-148-1.aspx