Post reply

Developing SSIS Packages

  • March 27, 2013 at 12:50 pm

    #147745

    I'm tired of typing this question into Google and getting 1,389,456 wrong answers. So I thought to myself, "Why don't you ask the experts?" So I'm here. I only have SSMS 2008 installed on my machine. I need to start developing SSIS packages. I know I need Visual Studio, but what version?

    I have Visual Studio 2010 Premium installed on my machine, but it doesn't have the capability to build SSIS packages. I know SQL Server installation media has Business Intelligence Development Studio on it, is that the only Visual Studio "version" that works for SSIS development?

    Thank you in advance!

  • March 27, 2013 at 1:34 pm

    #1601345

    SQL_Enthusiast (3/27/2013)

    I'm tired of typing this question into Google and getting 1,389,456 wrong answers. So I thought to myself, "Why don't you ask the experts?" So I'm here. I only have SSMS 2008 installed on my machine. I need to start developing SSIS packages. I know I need Visual Studio, but what version?

    I have Visual Studio 2010 Premium installed on my machine, but it doesn't have the capability to build SSIS packages. I know SQL Server installation media has Business Intelligence Development Studio on it, is that the only Visual Studio "version" that works for SSIS development?

    Thank you in advance!

    The short answer is no but to use VS2010 you need SQL Server 2012 for the package development and yes you can use VS2010 premium for BI development. And it is also better to use SQL Server Developer edition, that is the Enterprise edition with deployment restrictions. The reason is you have access to all the features you can use.

    Kind regards,
    Gift Peddie

  • March 27, 2013 at 1:54 pm

    #1601351

    BIDS is a trimmed down version of VS2010 with the project templates related to Business Intelligence installed.

    i have VS 2010 professional, and I have SQL 2008 standard installed on my machine; when i open Normal Visual Studio, i can create a new project, and select the right template; you should be able to do the same.

    AFAIK, it doesn't matter which order they are installed (VS2010, then BIDS, or vice versa), because the templates are installed in a common location.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 28, 2013 at 12:44 pm

    #1601801

    BIDS is all you need! Install it and go to town.

  • March 28, 2013 at 4:59 pm

    #1601913

    tmitchelar (3/28/2013)

    BIDS is all you need! Install it and go to town.

    The VS2010 Premium comes with more BI development templates than BIDS, I am running the Ultimate edition which includes Tabular projects.

    Kind regards,
    Gift Peddie

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply