batcater98
Programmer
I am using Visual Studio 2008 and building an SSIS package that uses the "SendMail Task". I am dynamically building the MessageSource from variables being passed in from an SQL task. Below is my current string, but I am trying to figure out how to insert "New Lines" in the statement.
Expression: "Employee Requested: " + @[User::EmpID] + "System: " + @[User::System] + "Data File: " + @[User::Source]
Output:
Employee Requested: 9994445 System: G BNVGAT4 04 Data File: \\Mydata\test
I would like it to read:
Employee Requested: 9994445
System: G BNVGAT4 04
Data File: \\Mydata\test
Is there a way to do this in an expression?
Thanks,
Ad.
Expression: "Employee Requested: " + @[User::EmpID] + "System: " + @[User::System] + "Data File: " + @[User::Source]
Output:
Employee Requested: 9994445 System: G BNVGAT4 04 Data File: \\Mydata\test
I would like it to read:
Employee Requested: 9994445
System: G BNVGAT4 04
Data File: \\Mydata\test
Is there a way to do this in an expression?
Thanks,
Ad.