Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Excel Connection Manager Error


SSIS Excel Connection Manager Error

Author
Message
Kicking_Fish0713
Kicking_Fish0713
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
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
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6228 Visits: 5314
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
Kicking_Fish0713
Kicking_Fish0713
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 124
I'm using 64-bit.
Thank you very much
Kicking_Fish0713
Kicking_Fish0713
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 124
I'm using 64-bit.
Thank you very much
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6228 Visits: 5314
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
Kicking_Fish0713
Kicking_Fish0713
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 124
I need additional detail. Thank you so much.
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6228 Visits: 5314
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search