March 9, 2011 at 12:30 pm
I want to use an expression in the connection manager that includes the task name of the task using it. Is this at all possible?
March 9, 2011 at 12:35 pm
Or Maybe even use the name of the connection string itself. Is there a system variable that holds that information?
March 9, 2011 at 12:45 pm
No and No.
A connection manager is not directly related to a specific task, so you cannot use an expression in a connection manager using some attribute of a task.
And there isn't a system variable that contains the name of the connection manager. If you have a variable that contains the name of the connection manager, then you can use this variable to set the name of the connection manager and for the desired expression.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2011 at 2:29 pm
As always, thank you Koen.
March 9, 2011 at 11:55 pm
Khades (3/9/2011)
As always, thank you Koen.
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply