July 31, 2009 at 1:21 pm
I am running a package from a SQL agent and I am receiving this error. I have looking and found this error list in many different forums, and have one question first.
Does Excel have to be installed on the box for the package to work? Personally I would think not. but I havent located that answer in connection with this error yet.
Thanks,
Swoozie
July 31, 2009 at 2:42 pm
One question - is this a 64bit server?
(excel doesn't need to be installed)
August 3, 2009 at 7:50 am
Yes it is a 64 bit server. So based on my first question, I guess I need to force it to go thru 32 bit. Which I tried but I must have the wrong syntax or I am calling it from the wrong place.
I created a job to run the ssis. In the Step that calls this SSIS package, in the Command Line tab, I place the syntax to go thru the 32 bit
Example: (Altered to our structure)
C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /f
The part I am having issue with is the syntax after
/DTS "\\" /SERVER /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
Not sure how to integrate the 2 peices together.
August 3, 2009 at 9:48 am
swoozie (8/3/2009)
C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /fThe part I am having issue with is the syntax after
/DTS "\\" /SERVER /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
You've got both /F and /DTS specified above as the package source, which I think will fail - you can only have one. I've only stored packages in MSDB, so the example for that is below, it has /SQL instead of /F(ile) or /DTS (package store)
The "." is for local server, this would all be on one line:
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /SQL "\" /SERVER "." /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E'
August 3, 2009 at 12:49 pm
hence, my not understanding the syntax pieces. Make all of the difference when you can understand all of the components.
I dont think I am doing too bad for 2 weeks and only references being the internet.
Thank you for the explanation of the /DTS vs the /F
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply