SQLTeam.com | Weblogs | Forums

Parameter as optional and override from SQL Job


#1

Dear Team,
I am using a string Parameter required as 'false' inside the package and passing the value from the Jobs configuration Edit literal value for expression...
The issue I am facing here is the value that I passing from the Job is adding double quotes for each word.
For Example : This is test value I am passing
This sentence is converted into: This "is" "test" "value" "I" "am" passing

I tried Replace function in the expression also.But it will replace all the quotes....(Suppose if I give word inside the quotes this one will also removed). But I want to remove the quotes added by the system

Could someone please help me to resolve this Issue......
Thanks and Regards,
Marun