Wednesday, June 08, 2005 - Posts

Server Instances and Integration Services Server

This is something you may run into, especially if you're running Integration Services on a machine with multiple instances and at least one of them is a SQL 2K instance.

The Integration Services server does not support instances, but is aware of SQL Server instances and can be configured to reference a particular instance. Here's how.

There is a file called MsDtsSrvr.ini.xml in the %PROGRAM FILES%\Microsoft SQL Server\90\DTS\Binn folder. If you open that file you'll see something like this:


There are a few interesting settings here, but this one determines which server the IS server will reference for enumerating packages in MSDB:.\YUKONB3


This tells the server to reference the local server instance named "YUKONB3". It can just as well be something like:
. or (local) or MYSERVERNAME etc.

If you make a change to this configuration file, make sure you restart the service in SQL Server Configuration Manager or the services control panel app.

Hope this helps,

Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden


                
 
    
				            
	
                        posted
                        Wednesday, June 08, 2005 12:53 PM by
						Knight_Reign with 
                        1 Comments    
                    

        

				               

                    
New articles available on Database Journal

                    
There is a new series covering Integration Services found here by Marcin Policht


It gives pretty good coverage, even talking about event handlers, editions, the service, and building dataflows. 


If this series is anything like his DTS one, it should become a good reference. 


Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden

                
 
    
				            
	
                        posted
                        Wednesday, June 08, 2005 9:58 AM by
						Knight_Reign with 
                        0 Comments    
                    

        

				               

                    
New MSDN Integration Services Forum

                    
There is a new forum available on MSDN dedicated to supporting Integration Services. This is now the official Integration Services touchpoint between customers, support folk and the Integration Services team.




 



 


There are a few features in this forum that make it worthwhile to switch over.


 


1) A few of us on the SSIS team get regular email informing us of any questions that haven't received a response. This should ensure that questions get a more prompt response.


 


2) There is opportunity for those asking questions to give feedback about the quality of the responses via the "Was this helpful" buttons.


 


3) There are no newsgroup settings to remember or lose, just save the link in favorites or even find it with your favorite search engine, or go to forums.microsoft.com and scroll down to it.


 


4) This is the official and main location where the IS team will go to answer questions as the beta newsgroup gets phased out.


 


5) You can subscribe to the forum as an RSS feed so you can read it along with other forums and blogs


 


6) More sophisticated filtering


 


7) At your fingertips links to other resources


 


Thanks,


Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden

                
 
    
				            
	
                        posted
                        Wednesday, June 08, 2005 9:12 AM by
						Knight_Reign with 
                        1 Comments