March 23, 2005 at 1:11 pm
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
March 23, 2005 at 2:57 pm
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