BI Daily : SSIS and LINQ
Before I suggest reading this article, let me pose one question. What is LINQ ? Well, if you are wondering that you have never come across this word in MSDN BOL, then you are correct and you should find the meaning to this word in .NET arena and not SQL Server arena.
Still this doesn't spare you from the need to answer this question. LINQ means Language Integrated Query, and it's a mechanism which is generally used in any managed code (.NET language code like VB.NET or C#) to query any data that is in any database format (i.e. structured format) or in memory (unstructured or XML format). LINQ has got it's use if you want to work with technologies like StreamInsight, which is one of the offerings of SQL Server 2008 R2.
Read this interesting post which explains how SSIS and LINQ can be used together.
URL: http://www.texastoo.com/post/2010/03/06/SSIS-and-LINQ.aspx , http://www.texastoo.com/post/2010/03/07/SSIS-and-LINQ-continued.aspx