george sibbald (7/12/2013)
the name of the SQL service in the cluster, i.e. the name you use to connect to the database engine.The packages are normally imported to msdb, thats better for security and backup. You can store them on the filesystem, on storage that is part od the cluster so it fails over with the cluster.
Yes you need to amend the .ini file so the server name points to the cluster name rather than '.' (on both nodes)
see http://dougbert.com/blog/post/ssis-and-clustering-what-you-should-do-instead.aspx
Do i set up sql server agent job on both nodes? I tried to create sql agent job using ssis package store using the cluster name (it does not show up) if I use actual note name then i can see MSDB folder. Is file system deployment the only option.
i read somewhere to copy .ini file to the shared disk and make the changes there instead of changing on both the nodes-is that for different setup ?
Thanks.