Appending text to a variable in SSIS
Posted on 2007-11-30
I have an "Execute SQL Task" in an dtsx package that sends an email using the following code...
@profile_name = 'SQL Mail',
@recipients = 'Test@test.com',
@copy_recipients = 'firstname.lastname@example.org',
@body = ?,
@subject = 'Some title' ;
This works fine, however I want to add more text to the body (as ? only supplies a single counter value)
I have tried a number of different versions of the code... the following is what I am trying to do...
@body = 'The number is: ' ?,
However this is not working... neither is @body = 'The number is: ' + ?,
If anyone out there knows how to get around this it would be much appreciated (the input variable ? is of type varchar)
Thanks in advance