March 26, 2007 at 11:39 am
I have taken over an existing project that has had several issues that need to be cleaned up. Recently a new issue started that has me scratching my head. It is a scheduled job that will not run one of the DTS packages. If I log on to the server, go into Enterprise Manager, and run the package manually it will execute without error. This started happening about a month ago and the only thing that has changed with this package is a reference to our new email host so that the report will get emailed once it has been completed. I have gone through and checked permissions and everything seems to be correct and excel is installed on the server.
The really strange thing with this is that the test environment will run it without a problem. The production environment and test environment are all on the same server, not ideal I know but that is what the original developer had to do for other reasons. So under the SQL Server Group we have a server called "(local)" and then another called "<ourprojectname>\test". And when you look at the job properties the radio button is checked for "Target local server" in both prod and test. When we schedule the job to run in the test environment it completes without an error. How can this be happening?
All of the code is the exact same between production and test, we have copied the entire package from test to production to be absolutely sure. We use an INI file to determine file locations and I have verified that the SA user has access to those as well. I even had the test environment access and save to the production folders as a test to be sure that it wasn't a permissions issue on the specific files and folders.
What other setting could be different between the two that could be causing this?
Here is the specific error: "Error Source= Microsoft VBScript runtime error. Error Description: ActiveX component can't create object: 'excel.application' Error on Line 8. Error Source: Microsoft Data Transformation Services (DTS)Package Help file:sqldts80.hlp help context:4500 Error: -2147220482(800403FE)."
Here is the line that it is complaining about:
set app = CreateObject("Excel.Application")
I have gone through a couple of suggestions that I found on this site as well as others while search through google but so far have not come up with a solution. If anyone has anymore insight I would greatly appreciate it! Thanks in advance!
March 26, 2007 at 12:53 pm
What user account is the job under? This sounds like a permissions issue. Might need to log on with that user account and make sure excel isn't trying to processes and install change (dialog will get in the way and an error will be thrown but I don't recall if this was the same message).
March 28, 2007 at 7:13 am
Everything is being run under the SA user. The test environment uses the same user account as the production environment and its all on the same server. The SA user account is controlled by our IT Services Dept. so I do not have the login information for it but I did have one of the admins from IT log in as SA on the server and try opening excel to make sure nothing was prompting them and it was not. They tried running the job and it still gave them the error message. Then I had them run the job in the test environment and that completed without error.
March 28, 2007 at 9:36 am
OK I finally found the article I had come across before as I have seen this. Take a look here and should help
http://support.microsoft.com/default.aspx?scid=kb;en-us;298725
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy