Deployment and Execution – Step 18 of the Stairway to Integration Services

  • Andy Leonard

    SSChampion

    Points: 10024

    Comments posted to this topic are about the item Deployment and Execution – Step 18 of the Stairway to Integration Services

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • Jo Pattyn

    SSC-Dedicated

    Points: 31401

    Eagerly awaiting the next edition.

    In case you need to run an ssis dashboard report not from the management studio, you can use a replacement by mnowill[/url].

    For readonly security on the catalog, one can check (link)[/url]

  • SQLPadawan

    Old Hand

    Points: 305

    Forgive me, Jedi Master!

    I disputed you. I didn't believe you could create more than SSISDB on a single operating system, BECAUSE if you look at the Feature Selection step of installation, as seen here http://www.e-squillace.com/tech/screenshotgallery/SQL/SQL2012/SQL2012_RTM_Install_Steps_files/Step9b-FeatureSelection-SQLFeatures.png, [SUPPOSEDLY] you can only install Integration Services once per operating system.

    So, I had to try out the claim that you could install SSIS on more than one instance per operating system. Of course, the Jedi Master was correct. So, Microsoft, a bit of clarification on the installation screen might help.

    Also, take a look at this person's hard work:

    http://speaksql.wordpress.com/2013/06/

    Scroll down to this section, "SSISDB ERD – A Journey to DB deployment automation" to see the reverse engineered SSISDB 2012!

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    SQLPadawan (5/21/2014)


    Forgive me, Jedi Master!

    I disputed you. I didn't believe you could create more than SSISDB on a single operating system, BECAUSE if you look at the Feature Selection step of installation, as seen here http://www.e-squillace.com/tech/screenshotgallery/SQL/SQL2012/SQL2012_RTM_Install_Steps_files/Step9b-FeatureSelection-SQLFeatures.png, [SUPPOSEDLY] you can only install Integration Services once per operating system.

    So, I had to try out the claim that you could install SSIS on more than one instance per operating system. Of course, the Jedi Master was correct. So, Microsoft, a bit of clarification on the installation screen might help.

    Also, take a look at this person's hard work:

    http://speaksql.wordpress.com/2013/06/

    Scroll down to this section, "SSISDB ERD – A Journey to DB deployment automation" to see the reverse engineered SSISDB 2012!

    I think you can install Integration Services only once per operating system (for a given edition), but this is just the SSIS service (not really used in the project deployment model) and the necesary binaries to run SSIS. You can however create multiple SSIS catalogs, i.e. one per database instance.

    You can also install multiple versions of SSIS, for example SSIS 2012 and SSIS 2014. I should test out someday how well they can live together on one system.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • er.lokeshsharma08

    SSC Veteran

    Points: 270

    Very clearly laid out. Thanks. My query is that I have sql server 2012 edition with sql server data tools (2010 edition). I have managed to make a ssis catalogue that can be seen in ssms. However my package project doesnt have a deploy option. Does it mean that deploy option is only available with sql server data tools 2012?

    Thanks

    Lokesh Sharma
    sql4all.org

  • SQLPadawan

    Old Hand

    Points: 305

    I have to ask the obvious. Are you right clicking on the Project, or the Package? Is the project in the Project Deployment Model or the former Package Deployment Model?

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    er.lokeshsharma08 (5/25/2014)


    Very clearly laid out. Thanks. My query is that I have sql server 2012 edition with sql server data tools (2010 edition). I have managed to make a ssis catalogue that can be seen in ssms. However my package project doesnt have a deploy option. Does it mean that deploy option is only available with sql server data tools 2012?

    Thanks

    You can use the 2010 edition to deploy SSIS projects.

    Make sure you are using the right deployment model and that you click on the correct object.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • er.lokeshsharma08

    SSC Veteran

    Points: 270

    I have created SSISDB in SSMS and then opening BIDS . Right clicking on the project (not on package) and there I cant get an option for deploy (i am getting build, rebuild and calculate code metrics). How would I enable project deployment model?

    Lokesh Sharma
    sql4all.org

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Right-click on project and convert to project deployment model.

    (you are working with VS2010 right?)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • er.lokeshsharma08

    SSC Veteran

    Points: 270

    Thanks ss i have converted it to project deployment model. a wizard came up , i selected the server name in (select source step). however i am stuck with the ssidb folder option. It doesnot let me create a new folder like (test in the example shown) and i cannot proceed further as ok button is disabled.

    Lokesh Sharma
    sql4all.org

Viewing 10 posts - 1 through 10 (of 10 total)

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