I have a Central Management Server configured and I have a production group that I would like to connect to with an SSIS package. Is this possible? Thanks in advance. Wade

Hi Wade, What are you trying to acheive in your SSIS package? Cheers JeffJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)

The package runs a series of inserts updates and deletes. Currently the package is executed on 5 different servers, which now reside in a group under my central management server. I would like to run the package once using the connection through the CMS.

If you want to run this package against multiple data sources/targets then you would need a SQL Agent job that would use different config setting, so it still can be one job, one package but you will execute it several times (on a per server basis), otherwise I do not understand how the package would know against what server to execute?Arthur My Blog

Well I was hoping the package could use the list of servers under a specific group on the Central Management Server.

1) You could create connection managers for 5 servers in the package and perform inserts/ updates right? Happy to help! Thanks. Regards and good Wishes, Deepak.