June 3, 2004 at 3:13 am
I hope someone out there can help me save a bit of time or perhaps a lot of work.
I have a dts job on the production server that creates an excel object using activex script, extracts data from the production database via a query and populates the excel spreadsheet.
The problem I have is that the production database does not have microsoft office instaled so when scheduled it falls over. I want to know, if I call the package from another server via another dts job (Execute package task) with microsoft office installed, will it process the job on that server and use ms office on that server.
At them moment I have to run the package manually on a pc using thin client and it works fine as I have microsoft office as part of my log in.
If the job has to run on the production server I will probably need to abandon the project full stop. I am only really using the spreadsheet approach till we get in business objects. I don't even have vb here, so I am severely restricted.
June 3, 2004 at 5:32 am
Jonathan,
The DTS package will run locally from wherever it is called. Instead of having a DTS package from Server2 call the package on Server1 why cant you just move the package to Server2 and make the changes so it will run on Server2?
This way you will know exactly where the package is running from and IF you are thinking about calling the package with a package the security is already established.
Good Luck,
Good Hunting!
AJ Ahrens
webmaster@kritter.net
June 3, 2004 at 8:06 am
Thanks. I did think about that but we have a flaky change control system here at best and I want to keep all the dts packages on the production database for visibility sake. That way anything missing will be immediately spotted.
A lot of the other servers could potentially be used in emergency and I do not want to lose anything if I can help it.
June 4, 2004 at 11:35 am
I'v run into the same issue where we had to generate Excel files and didn't have Office on the prod server. The way I was able to get around this was with a sp to create a jet 4.0 linked server to excel on the fly, export the data and drop the link. Been using this method to create multi-sheet workbooks each night for about two months now with no probs.
Just thought I'd throw out another option.
Good Luck
-Dave
June 7, 2004 at 7:28 am
Thanks for the advice. I have instaled office now but will remember this for next time.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply