Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS Expression Builder - New Line?

Status
Not open for further replies.

batcater98

Programmer
May 30, 2007
7
US
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.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top