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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.