DTS Step Error code: 800403FE

Hi Experts,

DTS today failed with error below.  It has been working fine until today.  Can someone please advise to resolve this error.

Step 'DTSStep_DTSActiveScriptTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft Office Excel
Error Description: Programmatic access to Visual Basic Project is not trusted
Error on Line 28
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500
Rainbow002Asked:
Who is Participating?
 
sk_raja_rajaConnect With a Mentor Commented:
(i) Check the SQL Server connection in the DTS package the job is running...it may be pointing to the old IP address instead of servername

0
 
Rainbow002Author Commented:
Thanks.
We didn't make any changes to the DTS.  DTS is running with Service account and it should be able to generate xls report which didn't happen.  This all started after we did fail over on cluster server.  
0
 
sk_raja_rajaConnect With a Mentor Commented:
yeah..make sure you give the new ip address or hostname in the DTs package.....its definitely a communication issue
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
nmcdermaidConnect With a Mentor Commented:
First hit on Google:
http://support.microsoft.com/kb/282830
It looks a security patch was added. You'll need to
1. Find out what user account the SQL Agent service is running as (assuming you are running this as a job)
2. Log on to the SQL Server and follow the instructions in the KB article.
0
 
nmcdermaidCommented:
sorry....
>> 2. Log on to the SQL Server **AS THE SQL Agent Service account** and follow the instructions in the KB article.
0
 
Rainbow002Author Commented:
Thanks All.  Actually macros security on xls had some issues which are resolved now.  Thanks for ur help.
0
 
nmcdermaidCommented:
I'm not sure why you assigned points to the other poster - it was totally incorrect and misleading.
0
 
JL NetworkCommented:
McAfee can prevent objects from being created such as CDO.message. We had the same problem and corrected it by configuring McAfee.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.