Hi! I'll keep getting this error: There was an error displaying the layout. Attempted to read or write protected memory error" in SSIS This happened suddenly in a data flow i one of the packages i have. All tasks in this specific dataflow have exclamation marks/"info icons" and when I try to open/doubleclick the datasource a big green arrow appears. Environment: Visual Studio 2008/BIDS, SQL server 2008 on windows 7 with latest service packs. I really dont know what to do, I' ve tried to reboot the machine but nothing seems to help and I' ve read the other threads with the similar error message but haven't seen a solution that works for me. /Peter

Maybe try re-installing BIDS?MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

A colleague checked out this package into his BIDS and he got the same error. In that case we both should reinstall our environments? Hopefully, that's the last option. :(

Suggests a follow up question. You can open other packages with BIDS with no problem? You can create new packages with no problems?Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008

Absolutely, there is no problem to open or create other packages in BIDS. But I did have this problem a couple of weeks ago in an other project, but I just ignored it. Because it was only in one package of totally 50 that struggled.

Hi There is a Hotfix for this error in Microsoft below is the link The hotfix can be downloaded from http://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=6003 The main cause behind it lies to the highly enhanced security features of .NET framework 2.0 over .NET 1.1. It has imposed several restiction , policies and permission sets for accessing the data from the web application, It uses full trust as well as partial trust. 1) If you try to access the data you don't have permission too or if the source is not trusted it gives the above exception. You not only have to give permission to your application to access the source BUT you need to make the source as trusted one too. 2)Also, the other main cause is that , if you try to read the data that is not available, it gives the above exception. So its time now to revise your concepts about CAS and permissions in visual studio.NET 2005 which is highly advanced than .NET 1.1. For details click the link below http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/foundstone.asp Go thro docs and decide which permission your application requires and implement it. Jai Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you Jai Shiva Naidu Verizon

Hi! Last time I gave up, the hotfix did never help me. So I deleted the entire package. But now I have received the same problem again, and I cant understand why? I hope we will upgrade VS/BID:s soon but I cannot take that decision by my self. Anyone out there that have had the same problem? /Peter

Hi! Okey, I have to confess that I might have found a minor solution/fix for this annoying error. First of all I think it happens only in those dataflows where I have a SCD component (Slowly changing dimension). Cause: The corrupt package was a copy(template) from another BIDS-project and in that package there was a configuration variable that was missing. (Indirect XML configuration file, environment variable) So when I removed this packagevariable, the error actually disappeared. The strange thing is that the error didnt appear immediately so I dont really know what was finally triggering the error. To confirm this, I should put this failing packagevariable back, but I dont dare. :) /Peter

Now the error is back again. Unbelievable, I give up. It looked so fine but suddenly the error came back. :( /Peter

Okey, it seems that no one is able to help me solving this specific problem? I looked in related topics and there were none SSIS related that was solved. So my question to microsoft or BIDS-team: Is this an accepted bug in BIDS? I can easy find others that have the same problem with no answers http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a772687d-3a8b-46f7-8108-0f6991508a7a http://social.msdn.microsoft.com/Forums/en-US/devdocs/thread/09e0f789-d58f-4978-b736-6db276ec1d1d http://social.msdn.microsoft.com/Forums/sr-Latn-CS/sqlintegrationservices/thread/153eec02-7639-4d1d-a300-8da7dcec0740 And here is some additional information =================================== There was an error displaying the layout. (Microsoft Visual Studio) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2008&ProdVer=9.0.30729.1&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=DDSErrorDeserializeDiagram&LinkId=20476 =================================== Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (msddsp) ------------------------------ Program Location: at MSDDS.IDdsDiagramObject.set_Top(Int32 Top) at Microsoft.DataWarehouse.Design.ComponentDiagram.AdjustDiagramObjects() at Microsoft.DataWarehouse.Design.ComponentDiagram.AfterDeserialize() at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.AfterDeserialize() at Microsoft.DataTransformationServices.Design.DataFlowDiagram.AfterDeserialize()

Okey, can someone please tell me where I can find help? I thought this was the place, but the moderator seems to avoid this one. Or do we have to choose another tool like SAS DI (Data Integration)? /Peter