February 6, 2014 at 11:14 am
Hi,
Does anyone know of a way to store a database connection string in an environment variable, but have the ability to set the Application Name by each package? I'd prefer not to have dozens of packages all showing up with the same Application Name when looking at spids.
February 6, 2014 at 11:38 am
Well, you can build the connection string with an expression appending the application name to a string parameter, and then map the parameter to the environment, I think.
Haven't done it, but that's what I'd try.
Or you can map just the servername and credentials individually to the environment instead of the whole connection string.
February 11, 2014 at 5:38 am
For any connection manager you can set different aspects of it when you configure your project/package in SSMS. So you can set the initial catalog, password, servername and username independantly of the connection string as a whole. Then you can use environment variables to change these values at runtime (dependant on the environment that you choose).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply