Hello Everyone, I want to know about Script component mainly i want to know that which VB_Version for scripting is used in SSIS 2005.

the script there is VSA (Visual Studio for Applications ) , and I think is based on VB.Net 2005 (maybe 2003). and you can only write VB.NET there. But in SSIS 2008, that is VSTA 2.0 (Visual studio tools for application) and can be written in VB.Net or C#. In SSIS 2011 it will comes up with VSTA 4.0http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

Thanks Reza, I wanted to know about the version of VB Script which i am using in SSIS 2005.

Thanks Reza, But I wanted to know about the version of VB Script which i am using in SSIS 2005. VSA (Visual Studio for Applications ) is an development envoirment where u can write ur script and run ur script. I wanted to know about the version of VB script

I think it is VB.NET 2.0 ( 2005 ), but as I haven't SSIS 2005 on my machine, I can not be sure. you can check it, do you have generics there? if yes, then it is VB.NET 2005 otherwise 2003.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

I m Not getting if is it VB.NET 2.0 ( 2005 ), or VB.NET 2003 which version is used in SSIS 2005 in Script tool pls provide me some suggestion or solution

It most likely to be VB.NET 2005, but I can not test it here, because I haven't SSIS 2005 on my machine. there are things in .NET 2005 which wasn't available in .NET 2003? they made available in .NET 2005 and doesn't exists in 2003, so just try them in script on SSIS 2005, if you could then this is .NET 2005, otherwise it is .NET 2003. for example VB.NET 2005 has using/end using structure, try to use it in SSIS 2005 script, does it make sense?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

for example VB.NET 2005 has using/end using structure this structure is also used by VB.Net 2003 I am getting confused . I Got following information regarding Script component 1)Visual Studio 2005 version 8.50727.0 2)Microsoft .Net Framework - 2.0.50727 Now can u please tell me that what will be the version of VB.Net i will be using here I m not getting this information.