xp_cmdshell exec ssis package in 32bit mode

• hardikr

  Old Hand

  Points: 301

  More actions

  November 8, 2013 at 5:03 am

  #1665058

  insert "@" before path..

  e.g. '@"C:\Program Files(x86)\....."

  It should work. I have tried this solution and I was able to execute it.

• vasanthreddys

  Newbie

  Points: 5

  More actions

  May 8, 2014 at 11:42 am

  #1711980

  Hi Try this,

  SET @QUERY='cd.. && "C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe" /f......

  print @query

  EXEC master.dbo.XP_CMDSHELL @QUERY

• puneet bisht

  Grasshopper

  Points: 18

  More actions

  May 19, 2014 at 5:12 am

  #1714578

  hi

  i am also facing the same problem , do any one have solution of this problem

• puneet bisht

  Grasshopper

  Points: 18

  More actions

  May 19, 2014 at 5:19 am

  #1714579

  i am importing excel in db but in stored procedure it is giving following error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80040E21 "(null)". This occurs when the ForEach Enumerator cannot enumerate.

  otherwise it is running fine in BIDS

• sunclep

  Grasshopper

  Points: 15

  More actions

  March 21, 2016 at 12:41 pm

  #1866587

  Please add @ before the double quotes.

  declare @cmd varchar(200)

  set @cmd = '@"c:\program files (x86)\microsoft sql server\100\dts\binn\dtexec.exe" /f "C:\Users\user1\Desktop\package.dtsx" '

  exec master..xp_cmdshell @cmd