Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connect SQL2008R2 SSIS to SQL2012 LocalDB ? Expand / Collapse
Author
Message
Posted Monday, February 25, 2013 5:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, July 13, 2013 3:47 AM
Points: 23, Visits: 24
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?
Post #1423573
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse