[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4090
  • Last Modified:

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
0
Rainbow002
Asked:
Rainbow002
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
sk_raja_rajaCommented:
(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_rajaCommented:
yeah..make sure you give the new ip address or hostname in the DTs package.....its definitely a communication issue
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
nmcdermaidCommented:
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now