Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

xp_cmdshell exec ssis package in 32bit mode Expand / Collapse
Author
Message
Posted Wednesday, May 4, 2011 8:43 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 17,967, Visits: 15,975
That seems to print fine. I have seen it in the past where it was throwing that error but was actually referring to the second set of items being quoted (the stuff you have after the /f). Try it without quoting that second file path.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1103212
Posted Wednesday, May 4, 2011 8:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:41 PM
Points: 45, Visits: 1,179
wow! thank you so much.
it worked without double quotes in the second part.
Post #1103224
Posted Wednesday, May 4, 2011 10:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 17,967, Visits: 15,975
Excellent - glad it worked.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1103267
Posted Friday, July 20, 2012 2:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 8:35 PM
Points: 2, Visits: 17
Hi,

How to add parameters to run the package?
Post #1332767
Posted Sunday, July 22, 2012 7:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 8:35 PM
Points: 2, Visits: 17
springmoonjc (7/20/2012)
Hi,

How to add parameters to run the package?


I got it. Thanks.
Post #1333574
Posted Friday, November 8, 2013 5:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:49 AM
Points: 7, Visits: 66
insert "@" before path..
e.g. '@"C:\Program Files(x86)\....."

It should work. I have tried this solution and I was able to execute it.
Post #1512615
Posted Thursday, May 8, 2014 11:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 8:16 PM
Points: 1, Visits: 61


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
Post #1569048
Posted Monday, May 19, 2014 5:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 2, Visits: 19
hi
i am also facing the same problem , do any one have solution of this problem
Post #1572221
Posted Monday, May 19, 2014 5:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 2, Visits: 19
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
Post #1572223
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse