DTS not running thru application using .NET

  • I have a DTS package that basically loads a file into a table.  The package runs great in EM but won't run thru the application.  The application is written in .NET.  I am not sure if I am having a permission problem.  Any advice is much appeciated.

     

    Thanks

     

     

  • Dorothy,

    Please post any error messages including relevant error messages in all 3 logs: application, security and system.

    If it does not help then use .NET ability to create logs /post errors into logs. There must be an error message somewhere.

    Check application's configuration file what security context the application is using. Give the appropriate permissions to this account. When working in EM you are working as a person who is specified in Registration Properties and this person runs a package. Schedule this package as a job and select Run As in the Job Properties->Step Properties->Advanced Tab and specify the account that .NET application runs under. As I said, you may figure it out in config file. Then run this job and see error messages in the job history.

    Yelena

    Regards,Yelena Varsha

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply