As we all are aware with expression usage in SSIS.
Lets see an example of using connector for creating dynamic connection.
We can create expression for connection string and assign it to connections.
So at rutime connection string from this expressions are evaluated first and based on it connection is made.
How SSIS does not giving any indication either connection has expressions defined not.
But from SQL 2012 we can see icon fro expression near the connection on which we have defined expression
see the example below
Here we defined expression for the connection so that we can see fx symbol near the connection
Lets see an example of using connector for creating dynamic connection.
We can create expression for connection string and assign it to connections.
So at rutime connection string from this expressions are evaluated first and based on it connection is made.
How SSIS does not giving any indication either connection has expressions defined not.
But from SQL 2012 we can see icon fro expression near the connection on which we have defined expression
see the example below
Here we defined expression for the connection so that we can see fx symbol near the connection
No comments:
Post a Comment