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

SSIS Excel Connection Manager Error Expand / Collapse
Author
Message
Posted Tuesday, September 22, 2009 8:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 21, 2012 1:19 AM
Points: 34, Visits: 124
Hello,
Can somebody help me on how to solve my problem in SSIS?
I've created SSIS,when I try to run this on the development,it works.
But on the job,the error is:
Argument "XLS" for option "connection" is not valid
Post #792329
Posted Tuesday, September 22, 2009 9:07 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,032, Visits: 5,283
Kicking_Fish0713 (9/22/2009)
Hello,
Can somebody help me on how to solve my problem in SSIS?
I've created SSIS,when I try to run this on the development,it works.
But on the job,the error is:
Argument "XLS" for option "connection" is not valid
Let me guess..

Your server is 64-bit...

You have to call the 32-bit version of DTExec..

If your server is 64-bit, reply back and I can go into further detail.

CEWII
Post #792335
Posted Tuesday, September 22, 2009 9:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 21, 2012 1:19 AM
Points: 34, Visits: 124
I'm using 64-bit.
Thank you very much
Post #792344
Posted Tuesday, September 22, 2009 9:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 21, 2012 1:19 AM
Points: 34, Visits: 124
I'm using 64-bit.
Thank you very much
Post #792345
Posted Tuesday, September 22, 2009 11:20 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,032, Visits: 5,283
To make it work you can't use the Integration Services Package type. You have to use Operating System type..

You need to find the full path to the 32-bit version of the DTExec.exe file. It will be down a path like C:\Program Files (x86)

You (unfortunately) have to spell out the entire command line including the full path to DTExec.exe, you can get most of the path by initially setting it up as an Integration Services type..

Do you need additional detail?

CEWII
Post #792368
Posted Wednesday, September 23, 2009 1:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 21, 2012 1:19 AM
Points: 34, Visits: 124
I need additional detail. Thank you so much.
Post #792394
Posted Wednesday, September 23, 2009 1:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,032, Visits: 5,283
Well what part isn't clear?

You can't use the easy way in Agent to run it, but you can use that to get most of the command line.

You need to find DTExec.exe, it will likely be somewhere under:
C:\Program Files (x86)\Microsoft SQL Server\90

You will use the full path to the DTExec.exe and the command line you got from Agent in the operating system command from agent..

CEWII
Post #792408
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse