 RE: SSIS Expression Builder Replace function -
03-13-2008
, 06:14 AM
Hi RMoore,
My apology, I forgot adding a backlash before the double quote. Try the
following now:
--------------------------------------------------------------------------
"SELECT 'TASKNAME="+@[System::SourceName]
+" ErrorStepID="+@[System::SourceID]
+" ErrorCode="+(DT_STR,15,1252)@[System::ErrorCode]
+" ErrorDescription=' + REPLACE('" +@[System::ErrorDescription] + "',
'\"','') AS ErrorMessage"
--------------------------------------------------------------------------
Please feel free to let me know if you have any other questions or
concerns. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======
 |
Linear Mode
