Wow - Guess I'm not the only one who was thrown for a loop by the answer to this question.

I have to agree that MDX is separate from TSQL. ...

You can use \r in the Send Mail Task by encapsulating them in quotes.

In Expression Builder, I would set up the MessageSource like so (formatting for readability only btw):

"line 1...

I'm sorry if I'm oversimplifying things here...

If you select EDIT on the OLE DB Destination task, you can redirect the records that fail on the insert by going into the...

Are your recipients internal customers/users that would have access to a network share? Could you send a link to the appropriate flat file as part of the body of...