I am executing a program from the Native Task command with an argument like "MailJob1" (without the quotes). I am storing this value in a variable and using the variable as the argument. This argument is supposed to match a field from an SQL table with the same name, again without quotes. When I debug the GA project, I get the following error: No JobID found in [SQLTable] for '"MailJob1"'. As you can see, there is an extra set of double quotes around MailJob1, and the program is erroring looking for a SQL field with a value that contains the quotes.
Is there a way to provide an argument for a native task without these double quotes being automatically added? Or any other non-intrusive work around?
Thanks in advance for any help.
Where you're seeing the double quotes is where the logging function wraps double quotes around the value in question, it it already has double quotes, then it appears and 2 double quotes.
If this is the case, then I believe that MSSQL (and most SQL Engines) will consider a double quoted field as a variable, not a value. For string literals, you'll need to use the single quotes surrounding the value you're trying to retrieve.
Lead Solutions Consultant