January 7, 2013 at 8:26 am
Hi,
I have a question regarding SSIS and Failover Clustering.
I am running SQL Server 2008 (SP1) with Integration services on one of the Instances.
After a system reboot the MsDtsSrvr.ini.xml file of the instance got changed back to the default and the servername (virtual servername of the instance) that was added in there were removed.
The resulted in the SSIS packages that were run by SQL Agent to fail because it could not be accessed.
How does this happen?
<a href=http://download.cnet.com/YouTube-To-MP3/3000-2071_4-75810474.html >youtube to mp3</a>
January 7, 2013 at 8:39 am
SSIS is not cluster aware.
http://msdn.microsoft.com/en-us/library/ms345193%28v=sql.105%29.aspx
January 7, 2013 at 8:49 am
I can't say I've seen that before, are you sure you modified the xml file the same on all nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply