Thank you for your reply.

I checked Internet Explorer Enhanced Security and this component is not installed on the Server.

This package used to work fine and it was giving...

I recon a bit more details will help understanding this problem.

I have an executable [say report.exe] which generates a report and emails them to the person who requested the reports....

The Executable does not popup any dialogue boxes for the user to respond. The DTS Package executes fine without any error /  problems when executed manually [Right click package and...

This job runs every 15 minutes and will be polling a particular table. If any records are found, it will process them.

The package when executed manually works fine [The executable also...