Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deployment and Execution – Step 18 of the Stairway to Integration Services Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2014 12:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
Comments posted to this topic are about the item Deployment and Execution – Step 18 of the Stairway to Integration Services

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1573010
Posted Wednesday, May 21, 2014 8:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 1,398, Visits: 6,417
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.
For readonly security on the catalog, one can check (link)
Post #1573225
Posted Wednesday, May 21, 2014 12:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, May 26, 2014 11:08 AM
Points: 64, Visits: 43
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!
Post #1573300
Posted Thursday, May 22, 2014 1:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 13,730, Visits: 10,684
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1573448
Posted Sunday, May 25, 2014 5:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 24, 2014 12:13 PM
Points: 10, Visits: 60
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
Post #1574380
Posted Sunday, May 25, 2014 5:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, May 26, 2014 11:08 AM
Points: 64, Visits: 43
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?
Post #1574422
Posted Monday, May 26, 2014 12:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 13,730, Visits: 10,684
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1574452
Posted Monday, May 26, 2014 1:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 24, 2014 12:13 PM
Points: 10, Visits: 60
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?
Post #1574590
Posted Monday, May 26, 2014 2:34 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 13,730, Visits: 10,684
Right-click on project and convert to project deployment model.

(you are working with VS2010 right?)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1574600
Posted Wednesday, May 28, 2014 1:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 24, 2014 12:13 PM
Points: 10, Visits: 60
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.
Post #1575322
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse