Hi, We are using the SSIS Sql Server 2008 R2. In that we are using the Script Task. In the Script Task we need to use the .NET 4.0 based dll(assembly) as we have to use .net 4.0 specific functionality in the script task. Will it possible to embed the .NET 4.0 based dll in the Script task? Is SSIS 2008 R2 compabile with .NET 4.0. If not, do we have to install sql service pack or any feature pack? Regards, Dhananjay

Following is the appropriate forum for your question: SQL Server Integration Services Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hi Dhananjay, I don't think you will be able to use .NET 4.0 in SQL 2008 because the script project allows selection of Target Framework up to .NET 3.5 . To use .NET 4.0 you have to start using the newer SQL 2012. Still it is at least worth a try to reference this .NET 4.0 library and see if you will be able to make use of it in the script.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Thanks for the inputs.