Problems running package using dtexec from cmd...

• Aleksandras Radajevas

  SSC Veteran

  Points: 252

  More actions

  October 4, 2007 at 3:30 am

  #375135

  Hi everybody.

  I'm trying to run a package, stored in MSDB, using dtexec utility from cmd.

  I do this using "dtexec /sq Main_Package /ser local /user sa /Password Oracle"

  But all I got is:

  Microsoft (R) SQL Server Execute Package Utility

  Version 9.00.3042.00 for 32-bit

  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

  Started: 12:14:15

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

  Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.

  Source:

  Started: 12:14:15

  Finished: 12:14:34

  Elapsed: 18.297 seconds

  It runs perfectly from "Integration Services" directly(SQL Management Studio), but not from cmd.

  I tried to run it withuot login and password, the same result

  Any ideas?

  Thanks.

• ripal.parikh

  Newbie

  Points: 3

  More actions

  May 1, 2008 at 10:44 pm

  #809925

  try to run it with

  dtexec /sq Main_Package

  dont use /ser local

  then it wont give u error