February 14, 2011 at 8:34 pm
When you configure SSIS on a cluster you can modify the MSDTSsvc.ini.xml file to allow SSIS to manage multiple MDBS as per this article: http://support.microsoft.com/kb/942176
You you see this:
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDBSV1</Name>
<ServerName>VSQLServ1\InstanceA</ServerName>
</Folder>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDBSV2</Name>
<ServerName>VSQLServ2\InstanceB</ServerName>
</Folder>
Can the file be modified to allow you to see multiple package stores on disk? I haven't seen this yet and the article doesn't say so, but could you do this:
<Folder xsi:type="FileSystemFolder">
<Name>File System SV1</Name>
<StorePath>\\ClusterVirtualName\SharedDriveP\Packages</StorePath>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System SV2</Name>
<StorePath>\\ClusterVirtualName\SharedDriveO\Packages</StorePath>
</Folder>
????
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
February 15, 2011 at 7:17 am
Leo.Miller (2/14/2011)
Can the file be modified to allow you to see multiple package stores on disk?Cheers
Leo
The following link quotes
Books On Line
You can modify the configuration file to allow packages to continue running if the service stops, to display additional root folders in Object Explorer, or to specify a different folder or additional folders in the file system to be managed by Integration Services service. For example, you can create additional root folders of type, SqlServerFolder, to manage packages in the msdb databases of additional instances of Database Engine.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2011 at 6:29 pm
Thanks all for the replies. None of the documentation is really that explicit. I've worked out that you can set this up and for each SQL Instance on the cluster you need to have a section like this:
<Folder xsi:type="FileSystemFolder">
<Name>File System InstanceName</Name>
<StorePath>\\VirtualSQLServerName1\X$\Packages</StorePath>
</Folder>
For each SQL Instance you would have a different >File System InstanceName< and this is for what the user sees from within Management Studio. You will also have a different Virtual SQL Server Name, and the X$ drive must be a shared resource in the same Cluster Resource Group as the Virtual SQL Instance. This way the Package folder is moved between nodes with all the other related resources. The full path can have other older levels if you want but I've kept it simple.
The files on both nodes of the cluster must match.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply