May 27, 2014 at 8:45 am
I have an enviroment variable I want to be used for all of my ssis packages to configure an OLEDB connection manager called SSISConfig. Each of my packages will have this connection and I will be setting the configuration for this to the EnviromentVariable named SSISEnviromentConfig to hold the connection string for the server and database Im gonna be using to hold my sql server table configs which the rest of the connections in the packages will use for thier configurations. Looking at the connection string inside the Enviroment variable I see a property called "Application Name". Right now this value is set to the name of the ssis package I set up to use it first. My question is will this cause the other packages to throw an error if they are using the Enviroment variable as well? Can I remove this value from the connection string?
I tried to use the enviroment variable in another package. When I try to set the SQL Server Config and select the SSISConfig as the Connection and select the table drop down I get an error that states: TITLE: System.Data
------------------------------
Format of the initialization string does not conform to specification starting at index 75.
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
May 27, 2014 at 12:53 pm
Application name is optional and should have no impact.
Could you post the connection string to see if it is valid (change servername and stuff like that).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply