Friday, March 9, 2012

DTS Package

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