September 22, 2009 at 8:33 pm
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
September 22, 2009 at 9:07 pm
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
September 22, 2009 at 9:33 pm
I'm using 64-bit.
Thank you very much
September 22, 2009 at 9:37 pm
I'm using 64-bit.
Thank you very much
September 22, 2009 at 11:20 pm
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
September 23, 2009 at 1:16 am
I need additional detail. Thank you so much.
September 23, 2009 at 1:38 am
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply