xp_cmdshell help needed

• BAGs

  Right there with Babe

  Points: 793

  More actions

  February 5, 2010 at 2:41 pm

  #141088

  HI folks

  Looking for some help.

  i have created a package and want to run it using EXEC xp_cmdshell 'dtexec.

  Here is my exact line:

  EXEC xp_cmdshell 'dtexec /f \\frafile6\adcirc\MerchSys\SQLServer\SSIS_Packages\SlsSkuWkLoc.dtsx'

  I have triple checked the file location.

  Any help will be appreciated and let me know if you need more information.

  thanks in advance.

  Here is the return errors:

  Microsoft (R) SQL Server Execute Package Utility

  Version 9.00.4035.00 for 32-bit

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

  NULL

  Started: 4:36:47 PM

  Error: 2010-02-05 16:36:47.48

  Code: 0xC0011007

  Source: {71232F92-D7FB-4372-A6A8-6F7B0DD04A5D}

  Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.

  End Error

  Error: 2010-02-05 16:36:47.48

  Code: 0xC0011002

  Source: {71232F92-D7FB-4372-A6A8-6F7B0DD04A5D}

  Description: Failed to open package file "\\frafile6\adcirc\MerchSys\SQLServer\SSIS_Packages\SlsSkuWkLoc.dtsx" due to error 0x80070005 "Access is denied.". This happens when loading a package and the file cannot be opened or loaded correctly into the

  XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.

  End Error

  Could not load package "\\frafile6\adcirc\MerchSys\SQLServer\SSIS_Packages\SlsSkuWkLoc.dtsx" because of error 0xC0011002.

  Description: Failed to open package file "\\frafile6\adcirc\MerchSys\SQLServer\SSIS_Packages\SlsSkuWkLoc.dtsx" due to error 0x80070005 "Access is denied.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML

  document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.

  Source: {71232F92-D7FB-4372-A6A8-6F7B0DD04A5D}

  Started: 4:36:47 PM

  Finished: 4:36:47 PM

  Elapsed: 0.188 seconds

  NULL

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  February 5, 2010 at 7:55 pm

  #1114894

  The SQL Server service must be logged in as a Domain account that can see the path that you're using xp_CmdShell to point to.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)