locked
Package migration from SSIS 2008 R2 to SQL server 2012 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi guys:

      My company has decided to use Sql server 2012 for the database service, Integration service as well as analysis service

      The first question is which tool I should install to run packages ? in SQL Server 2008 R2, I've installed BIDS which is inside the disk.

      Also do I need to install any visual studio tools? I was under the impression that the BIDS 2008 was using kinda shell visual studio. 

     Thanks

     Hui


    --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

    Wednesday, February 12, 2014 2:25 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    When you install the SQL Server 2012 edition it also gives you the option of installing a VS 2010 Shell [ When you check the SSDT option]. That will allow you to create and edit packages for SQL Server 2012.

    SSDT Installation SQl Server


    Regards, Dinesh


    • Edited by Dinesh Menon Wednesday, February 12, 2014 6:39 PM Added URL
    • Proposed as answer by Mike Yin Friday, February 14, 2014 5:07 PM
    • Marked as answer by Mike Yin Sunday, February 23, 2014 5:09 PM
    Wednesday, February 12, 2014 3:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Russ. Our company is currently using Visual Studio 2013.  If I install VS 2013 and then install SSDT-BI for VS2012. Next time when I open VS2013, can

    I author any BI projects from VS2013 directly?


    Not at all.  You can use VS2010 or VS2012. 

    Russel Loski, MCT, MCSE Data Platform/Business Intelligence. Twitter: @sqlmovers; blog: www.sqlmovers.com

    • Proposed as answer by Mike Yin Friday, February 14, 2014 5:07 PM
    • Marked as answer by Mike Yin Sunday, February 23, 2014 5:09 PM
    Wednesday, February 12, 2014 9:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi cat_ca,

    To develop package in SQL Server 2012 Integration Services, we use the SQL Server Data Tools (SSDT 2012) which can be installed from the SQL Server 2012 install media. The SSDT 2012 use Visual Studio 2010 shell by default and can be integrated into Visual Studio 2010. By installing SQL Server Data Tools - Business Intelligence for Visual Studio 2012, we can also integrate SSDT 2012 into Visual Studio 2012. However, SSDT 2012 cannot be integrated into Visual Studio 2013. As far as I know, the SSDT 2014 released in SQL Server 2014 RTM will use the Visual Studio 2013 shell and can be integrated into Visual Studio 2013.

    Regards,

    Mike Yin
    TechNet Community Support

    • Marked as answer by Mike Yin Sunday, February 23, 2014 5:09 PM
    Friday, February 14, 2014 5:09 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    I would install the SSDT (SQL Server Data Tools - Business Intelligence for Visual Studio 2012).  This provides the Visual Studio version you need with the appropriate templates.  http://msdn.microsoft.com/en-us/library/jj856966.aspx

    Russel Loski, MCT, MCSE Data Platform/Business Intelligence. Twitter: @sqlmovers; blog: www.sqlmovers.com


    • Edited by Russ Loski Wednesday, February 12, 2014 3:03 PM
    Wednesday, February 12, 2014 3:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    When you install the SQL Server 2012 edition it also gives you the option of installing a VS 2010 Shell [ When you check the SSDT option]. That will allow you to create and edit packages for SQL Server 2012.

    SSDT Installation SQl Server


    Regards, Dinesh


    • Edited by Dinesh Menon Wednesday, February 12, 2014 6:39 PM Added URL
    • Proposed as answer by Mike Yin Friday, February 14, 2014 5:07 PM
    • Marked as answer by Mike Yin Sunday, February 23, 2014 5:09 PM
    Wednesday, February 12, 2014 3:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Russ. Our company is currently using Visual Studio 2013.  If I install VS 2013 and then install SSDT-BI for VS2012. Next time when I open VS2013, can

    I author any BI projects from VS2013 directly?


    --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

    Wednesday, February 12, 2014 8:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Russ. Our company is currently using Visual Studio 2013.  If I install VS 2013 and then install SSDT-BI for VS2012. Next time when I open VS2013, can

    I author any BI projects from VS2013 directly?


    Not at all.  You can use VS2010 or VS2012. 

    Russel Loski, MCT, MCSE Data Platform/Business Intelligence. Twitter: @sqlmovers; blog: www.sqlmovers.com

    • Proposed as answer by Mike Yin Friday, February 14, 2014 5:07 PM
    • Marked as answer by Mike Yin Sunday, February 23, 2014 5:09 PM
    Wednesday, February 12, 2014 9:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    VS 2013, does mess up your set up completely. I second Russ's opinion. You should use either VS 2010 or VS 2012

    Regards, Dinesh

    Wednesday, February 12, 2014 9:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi cat_ca,

    To develop package in SQL Server 2012 Integration Services, we use the SQL Server Data Tools (SSDT 2012) which can be installed from the SQL Server 2012 install media. The SSDT 2012 use Visual Studio 2010 shell by default and can be integrated into Visual Studio 2010. By installing SQL Server Data Tools - Business Intelligence for Visual Studio 2012, we can also integrate SSDT 2012 into Visual Studio 2012. However, SSDT 2012 cannot be integrated into Visual Studio 2013. As far as I know, the SSDT 2014 released in SQL Server 2014 RTM will use the Visual Studio 2013 shell and can be integrated into Visual Studio 2013.

    Regards,

    Mike Yin
    TechNet Community Support

    • Marked as answer by Mike Yin Sunday, February 23, 2014 5:09 PM
    Friday, February 14, 2014 5:09 PM