September 15, 2011 at 3:20 am
Hi
We are running sql 2008 Enterprise R2. I have created a ssis package to retrive data from our AS400 server.
The package is created and connection is tested and reports ok. (Our system will not create the packacge unless it has contact between those two systems. So I know that the login info and server info is correct.)
When I try to run the package it fails with this code:
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536.
The server may be running out of resources or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS
or UNSAFE. Run the query again<c/> or check documentation to see how to solve the assembly trust issues.
Seems to be something with security or user. But not sure what and how to solve it.
Anyone out there who knows something about this?
Regards
Dan
September 15, 2011 at 3:28 am
Hi.
I found the solution to this problem.
I had to change some properties on my databases.
Found my solution here:
http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/2465ac11-735c-4362-8da4-1ed672b0e261
I had to set all my databases trustworthy with this code sniblet:
ALTER DATABASE <DatabaseName> SET trustworthy ON
Dan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply