September 27, 2011 at 9:41 pm
Comments posted to this topic are about the item Installating SSIS with Named Instance
September 27, 2011 at 9:41 pm
Good question, got to know something
M&M
September 27, 2011 at 10:00 pm
Definitely worth knowing
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2011 at 1:54 am
Interesting QOTD.
September 28, 2011 at 2:10 am
This was removed by the editor as SPAM
September 28, 2011 at 3:17 am
If you have multiple instances of SQL Server, then you need a <ServerName> node that describes each instance. I am not sure the question makes this clear.
If you use FineBuild to install your instances, then this work is done for you automatically.
Also, if you install a SQL cluster and are certain you will only ever have one SQL instance on the cluster it is safe to setup SSIS as a cluster. If you want a SSIS cluster, use the parameter /SetupSSISCluster:Yes and FineBuild will build the SSIS cluster, setup a Package Store folder on a shared drive, and update MsDtsSrvr.ini to allow SSIS to recognise both the shared msdb database and the shared package store folder.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 28, 2011 at 4:43 am
Got to learn something, I am yet to explorer SSIS settings may be I will understand it clearly when I get the time to learn SSIS in detail...
September 28, 2011 at 5:49 am
As I work in a shop with multiple DBA's, I don't always get to "fiddle" with the configuration. Definitely learned something today. Thanks for the question.
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
September 28, 2011 at 6:35 am
Great question.
Matt
September 28, 2011 at 7:37 am
I can tell you from personal experience, in an environment where we are moving to multiple instances on huge workhorse cluster systems, that this is a critical thing to know. Integration Services won't work properly if you need to use the MSDB portion of IS storage. That said, if you keep packages in the file system and only use SQL Agent to run them as jobs, you don't even need Integration Services. You can supply all of the detail in the job creation to run the package without use of Integration Services (which is the preferred method at our shop, though not always possible with third party apps, thus the criticality of today's question).
September 28, 2011 at 7:58 am
Great question rfr.
Been looking forward to it since you posted that you submitted a question.
I was not disapointed.
September 28, 2011 at 8:53 am
good question
September 28, 2011 at 9:38 am
Great question. The referenced article has a really good overview of how this all hangs together, too. Definitely learned something today!
Rob Schripsema
Propack, Inc.
September 28, 2011 at 9:44 am
I had no idea but made a lucky guess based on the answer that looked like it might be correct.
September 28, 2011 at 10:05 am
Great question, caught me on this one. But now I know better.:-)
Not all gray hairs are Dinosaurs!
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply