locked
SSIS script task using visual c# 2012 language when creating package in Visual Studio 2013 RRS feed

  • Question

  • Is it right or my installation was all wrong.

    When I am trying to use a script task in an SSIS package using Visual Studio 2013, the available languages are visual c# and VB 2012.

    I was expecting to find visual c# and VB 2013 since I was using Visual Studio 2013.

    I already installed the "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013" available for sql 2014

    Please help clarify this. Thanks beforehand.


    Paulino

    Friday, January 16, 2015 9:38 PM

Answers

  • The installation is correct.

    The .net framework of say 2012 of SSIS runs on .net version 4 which is not compatible with C# version that comes out with VS 2013 but it possible to switch the target .net frameworks http://www.bimonkey.com/2011/09/using-net-framework-3-5-in-ssis-scripts/

    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Koen VerbeeckMVP Tuesday, January 20, 2015 2:31 PM
    • Marked as answer by Paulino PP Tuesday, January 20, 2015 3:57 PM
    Saturday, January 17, 2015 1:09 AM

All replies

  • The installation is correct.

    The .net framework of say 2012 of SSIS runs on .net version 4 which is not compatible with C# version that comes out with VS 2013 but it possible to switch the target .net frameworks http://www.bimonkey.com/2011/09/using-net-framework-3-5-in-ssis-scripts/

    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Koen VerbeeckMVP Tuesday, January 20, 2015 2:31 PM
    • Marked as answer by Paulino PP Tuesday, January 20, 2015 3:57 PM
    Saturday, January 17, 2015 1:09 AM
  • Hi Paulino,

    According to your description, the ScriptLanguage property of C# script tasks show "Microsoft Visual C# 2012” in SSDT-BI for VS 2013.

    After testing the issue in my environment, I can reproduce it in SSDT-BI for VS 2013. And I find that the ScriptLanguage property of C# script tasks show "Microsoft Visual C# 2010” in SSDT, and show "Microsoft Visual C# 2012” in SSDT for SSDT – BI for VS2012. It only appear in SSDT-BI for VS 2013.

    The issue is by design. But we can check "Do not show this again." to ignore the dialog and the task can be executed without any problem.

    The following feedback is for your reference:
    https://connect.microsoft.com/SQLServer/feedback/details/1027035/ssdt-bi-for-vs-2013-compatibility-issue

    Regards,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Tuesday, January 20, 2015 10:36 AM
  • Arthur, thank for reply.

    I my case I am not looking for a particular .net framework. If by design VS2013 come with Visual C# 2012 and VB 2012 I can work with that. I just wanted to make sure the install was ok.

    Thanks for clarifying that the installation is correct, that statement right there is was I was looking for.

    Thanks so much for your time


    Paulino

    Tuesday, January 20, 2015 2:07 PM
  • Hi Katherine. Thanks for checking on my inquiry. Thanks for testing in your environment. Unfortunately the link provided did not work. Yet, based on what you are finding. I should be just fine using visual c# and VB 2012 while working on VS 2013. Thanks!

    Paulino

    Tuesday, January 20, 2015 2:12 PM