November 2, 2012 at 12:58 am
Hi all,
When i'm trying to format an expression i'm getting an error saying the token "\" in the line no 1 is not recognized
"Dear All, "+""+@[System::PackageName] + " SSIS packagee has failed.+""+ The task that has failed is: " + @[System::SourceName] +""+ " Errorcode: " + @[System::ErrorDescription] + "" + " This is registered on " + (DT_STR, 40, 1252) @[System::EventHandlerStartTime] + ""+" User: " + @[System::UserName] +""+ "Server: " + @[System::MachineName] + ""+" Packagestart: " + (DT_STR, 40, 1252) @[System::StartTime]+""+ "Best Regards ," + ""+"IT Team
i want to format it like as below
Dear All,
Package name SSIS packagee has failed.
The task that has failed is: task name
Errorcode: Executing the query "EXEC cfg.sp_InsertProcessStatus_Success ?" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
This is registered on 11/1/2012 1:54:43 PM
User:
Server:
Packagestart: 11/1/2012 1:54:41 PM
Best regards,
IT Team,
Pls let me know what is wrong in the expression
November 2, 2012 at 2:25 am
You don't close your final " at the end. (that might be a copy pasting issue when you pasted the expression into the forum)
You have several line breaks, but your expression just shows + "" + .
What is really there in the expression?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 2, 2012 at 2:42 am
It is ""
November 2, 2012 at 2:46 am
Check your "
There are a few missing and a few that don't belong.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 2, 2012 at 2:52 am
i got it
Thanks a lot for the reply 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply