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

Question

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

Andy Leonard

SSChampion

Points: 10144
More actions
May 21, 2014 at 12:05 am

#293479

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

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

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

Jo Pattyn SSC-Dedicated Points: 32350 More actions · Answer 1

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: 369 More actions · Answer 2

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: 259115 More actions · Answer 3

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 More actions · Answer 4

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: 369 More actions · Answer 5

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: 259115 More actions · Answer 6

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 More actions · Answer 7

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: 259115 More actions · Answer 8

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 More actions · Answer 9

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