Hi Everyone,
I have a DTS pcakage. I am calling an exe file in that DTS pcakage. This DTS package is running on another server. Whenever I directly try to execute a package, it runs fine, but when I run it as a job, it fails giving me this error message
Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
Any help will be grealy appreciated.
Thanks.
I covered it for you here now you have to create a proxy account for your admin permissions to run DTS under the context of the Agent. It will take time but it works. Hope this helps.
http://forums.asp.net/thread/1410960.aspx
No comments:
Post a Comment