November 4, 2008 at 10:41 am
We have over 100 SSIS and DTS (will be migrated to SSIS) packages that are distributed over 7 servers. I would like to consolidate them onto one server that can be clustered and set for automatic failover.
If someone has successfully been able to do this, whatever info you would like to share would be greatly appreciated.
Thanx, for the help.
Enjoy
"Give them the tools:crazy: ... Not the keys:smooooth:"
November 4, 2008 at 11:01 am
Interestingly enough, SSIS is not a cluster-aware resource.
Here are some articles:
http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx
November 4, 2008 at 12:59 pm
thanx for the quick reply ...
Enjoy
"Give them the tools:crazy: ... Not the keys:smooooth:"
November 5, 2008 at 5:19 am
Looks like your question has already been answered, but I've found out over the past few months personally that SSIS is not cluster aware. Also if you are looking to transfer those packages across you will have to make sure they exist on each node within the cluster as it will not recognise the packages on one node when it fails over to another node. A real pain!
Dan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply