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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 21,350, Visits: 15,027
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
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, July 8, 2014 3:20 PM
Points: 44, Visits: 1,148
wow! thank you so much.
it worked without double quotes in the second part.
Post #1103224
Posted Wednesday, May 4, 2011 10:09 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 21,350, Visits: 15,027
Excellent - glad it worked.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
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: 2 days ago @ 3:30 AM
Points: 7, Visits: 62
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: Thursday, July 10, 2014 7:40 AM
Points: 1, Visits: 51


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: Monday, May 26, 2014 5:38 AM
Points: 2, Visits: 17
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: Monday, May 26, 2014 5:38 AM
Points: 2, Visits: 17
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