SSIS : DTExec help

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  November 27, 2007 at 1:20 pm

  #377192

  hi,

  Ih ave SQL server 2005 Std edition running. I have package that i am trying to run. the package is stored in Database.

  SSIS--> MSDB --> Package1

  Now i am trying to run as command line which is:

  the bat file is as followed:

  "D:\Apps\90\DTS\Binn\DTExec.exe" /SQL "\MSDB\Package1" /SERVER servername1

  I get this error:

  Could not load package "\MSDB\Package1" because of error 0xC001

  62.

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

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

  how can i solve it!!

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  November 27, 2007 at 2:23 pm

  #754731

  Hi Pat,

  I think the syntax should be:

  D:\Apps\90\DTS\Binn\DTExec.exe" /SQL "\Package1" /SERVER servername1

  Verify with the DTEXECUI util. Set it up and look at the command line item.

  Norman

  DTS Pacakge Search

  http://www.dtspackagesearch.com/

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  November 27, 2007 at 3:04 pm

  #754745

  Hi,

  I still get same error message!!

  Thanks