SSIS Connection manager not saving changes.

Question

Hello!

I have an SSIS issue with a package level connection manager.

I'm using Visual Studio Professional 2012.

The connection manager is a Dynamics CRM Lookup Connection Manager with provider Native OLE DB\SQL Server Native Client 11.0

For this connection manager I am using SQL Server Authentication and am connecting to a database. Lets call this database DB1.

I need to update DB1 to DB2.

I do this, then test the connection. The test result returns successful following this I click 'OK' which then supposedly saves the connection manager updates and applies them to the SSIS package.

However the package is NOT updated and when I re-open the connection manager the old DB1 information is shown.

Does anyone have any idea why this behaviour is occurring as I urgently need to update this connection manager without removing and re-creating it.

Answer 1

This question is outside the scope of this site (for consumers) and to be sure you get the best (and quickest) answer it should be asked either on Technet (for IT Pro's) or MSDN (for developers)

*

http://social.technet.microsoft.com/Forums/en-us/home s/en-US/home

http://social.msdn.microsoft.com/Forum

---

If you give us a link to the new thread we can point some resources to it