One of the great things I love about the new delivery of BOL content is the change history. This is great to find new stuff. I had a quick look today and say that there was a section for deprecated features in SSIS.
What its only 6 months old and they're already cutting stuff.
Well yep they ar cutting VSA (Visual Studio for Applications), why because it is tied to vb.net and not the rest of the .net family. And the primary solution for scripting in .Net is VSTA (Visual Studio Tools for Applications). Whilst it doesn't say that it will support C#, that is what VSTA brings to the table and so can't see why it won't for SSIS.
Yippee
Here is the excerpt from BOL
"Microsoft Visual Studio for Applications (VSA)
In future versions of Integration Services, Visual Studio for Applications (VSA) will be replaced with Visual Studio Tools for Applications (VSTA) as the engine in the Script task and Script transformation. While this change is not anticipated to incur a dramatic departure from existing syntax, this change may require script conversions when migrating to the next version of Integration Services.
In the next version of Integration Services:
- Microsoft will support the conversion to VSTA of existing Script task and Script transformation scripts authored in VSA.
- Microsoft will support execution of existing non-compiled VSA scripts.
In future versions of Integration Services:
- Microsoft will support the conversion to VSTA of existing Script task and Script transformation scripts authored in VSA
- Microsoft will not support execution of VSA scripts."