You must have already downloaded the SP2 now. If not, here is the link. Note that new samples are not included with it. Samples can be downloaded from here and readme file from here if want.

Did you notice that there is a new sample database called AdventureWorksLT?

If you make search on it, you will definitely find enough information related to it. But since I experienced it, thought to blog. Assume that we have a .net class that is written with c#.net. Now I want to use one of the methods in that class in my SSIS package. Simply, I add “Script Task” and open the "Design Script" window by using edit menu item of it.

As usual, I have to reference the assembly, open the "Add Rererence" dialog box. My assembly is located in one my working folder; need to browse it for adding. But I found NO browse button and my assembly is not listed too. The reason is, I can use only assemblises located in "C:\WINDOWS\Microsoft.NET\Framework\v2.x.xxxxx" folder, means, I have to copy my assembly into that folder. Once copied, I referenced and design-time availability is okay.

Now the run-time. Can I run without any problem? No, I get "Could not load file or assembly....." error. Now the reason is, if SSIS accesses any assemblies, they should be exist in the GAC. Once my assembly is added to the GAC (of course, it need to be signed), it started working as I want; I can access the .net classes through SSIS.