HelloI have script task that has references added to it but still giving me above error? How should i resolve this situation?Thanks

Hi Harris001,Try the following steps: Deploy the assembly containing the class in the appropriate place Reference the class in your Script Task To be able to reference an assembly from Visual Studio for Applications, you must put the assembly in the following system folder: C:\WINDOWS\Microsoft.NET\Framework\v2.0.nnnnIn addition, you must deploy the assembly in the Global Assembly Cache (GAC).Regards,Tarek Ghazali---------------------------------------SQL Server MVPWeb Site: http://www.sqlmvp.com

Most probably u need to put the DLL in the folder C:\WINDOWS\Microsoft.NET\Framework\v2.0.507 & Assembly Hope this helps !! - Sudeep

Thank you both for you response,I did both, placed it in C:\Windows\Microsoft.Net\Framework\v2.0.nnnn and deployed in GAC (C:\Windows\assembly)The dll's were not strong named so i strong named them befor i deployed in GAC.Still when i go and add reference to these dll's it seem to be referenced to wrong version because when i mouse over it, it shows public key null... and when i right click the added reference and check properties it does say strong name as true...i am completely lost and stressed trying to fix this one....any suggestions would be great help...Harris

Hi Hariss001, Make sure the PreCompile property of your script task/component is set to TRUE. Regards, Tarek Ghazali ---------------------------- SQL Server MVP http://www.sqlmvp.com

Unlike earlier versions where you could indicate whether the scripts were precompiled, all scripts are precompiled in SQL Server 2008 Integration Services (SSIS). When a script is precompiled, the language engine is not loaded at run time and the package runs more quickly. However, precompiled binary files consume significant disk space.http://msdn.microsoft.com/en-us/library/ms141752.aspxSo that GAC Solution seems to be the only option.... and nowI need to find out how to get it in there.

Here is an example of using a custom assembly within a Script Task or Script Component: http://microsoft-ssis.blogspot.com/2011/05/referencing-custom-assembly-inside.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Hello All,I have a question and i am not able to get answer ..i have not got visual studio on my system but i am adding an external assembly to my script task in ssis.Now the question is there a way to add assembly into GAC without visual studio command prompt?

Hello All,I have a question and i am not able to get answer ..i have not got visual studio on my system but i am adding an external assembly to my script task in ssis.Now the question is there a way to add assembly into GAC without visual studio command prompt? I think you can just drag the dll to the GAC folder (if the DLL is strong named). PS BIDS = Visual Studio. So maybe it's there. Shortcut location: %comspec% /k ""C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\vcvarsall.bat"" x86 %comspec% /k ""C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\vcvarsall.bat"" x86 %comspec% /k ""C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\vcvarsall.bat"" amd64Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter