Read the title carefully and take it literally. I had discussions with people trying to convince me this is indeed possible. What they were trying to explain to me is the following: Let's take a SQL Server Management Studio 2008 and connect to a SQL Server Integration Services 2005 instance. Proof can be found here . It won't...
I always was kind of dissapointed I couldn't use C# in the SSIS Script Task but my dream came true in SQL Server 2008. Read this excellent post from Denis Gobo!