Can I connect a SQL2008R2 SSIS package to a SQL2012 localDB to update data on the localDB used by the user applications ?
looking at the documentation it seems like this should be possible but that the connection string will change each time that that LocalDB is started (containing pipe connection port number?). Would the only way to find what the connection needs to be is to run the SQLLocalDB.exe asking for info to get the instance pipe name?