job fails
Hi all
In windows 7 , Microsoft Excel Application in DCOMCNFG is not found
so am not able to run the job.
plz help me....where i will install or some other option is there.....nathan
September 5th, 2011 6:05am
Don't think this is a SSIS question....Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 6:51am
ya ...but while running a ssis package am getting error .
so plz help me on this ....nathan
September 5th, 2011 7:00am
Hi Nathan,
Can you post the error message here?Sharath
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 7:28am
So it is running in BIDS, but not as a job?
Common problems for jobs are:
- 32 bits vs 64 bits (especially for office), try to run on 32bits
- authorization of the user that is running the job, check if that user has enough rightsPlease mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
September 5th, 2011 7:37am
no,.......... It is job only ....If i run the package is working fine but i schedule package it shown error.
am using window 7 .
note : If i run the job in window 2003 and dcom component i given access to Microsoft excel application then the job working perfectly .
If i run the job in window 7 and searching for Microsoft Excel Application in DCOMCNFG is not found .
this is the problem ...help me on this.
am using SQL sever 2008 r2.nathan
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 7:46am
Hi all
Problem solved ....I created desktop folder in this path C:\Windows\SysWOW64\config\systemprofile
then i Run the job in sql server and
its working fine,...
Thanks For reply all......nathan
September 5th, 2011 9:05am