I have a data source defined but when I go to add a script step, it doesn't show up in the list. The first screenshot is the Manage External Data Sources. The second is from the Execute SQL script step.
The file may be hosted on FMS.
ESS use DSN defined on server, but Execute SQL use DSN on client.
Thanks for the info. The file is hosted on FMS.
I get an error but I don't see the incorrect pairing of quotes. I've printed the line out and checked of matching quotes.
Your variables (maybe $Title) contain ' in the values.
It is better to use ? parameter syntax.
Or, replace ' to '' (two single quotes) for text value.
... & Substitute ( $var ; "'" ; "''" ) & ...
Retrieving data ...