Struggling to Read and Execute .SQL file (TSQL)

Question

Starting with file path to a .sql file, I'm trying to read the query and execute using Dynamic Input.

In Dynamic Input I have connected to the DB and entered a dummy query eg. 'replaceme' (no quotes) and I'm trying to replace THAT with my query (in [Query] field) using 'Replace a Specific String'

However I'm getting the following errors:

Error: Dynamic Input (14): Error SQLExtendedFetch: [Microsoft][ODBC Driver 17 for SQL Server]Invalid cursor state

Info: Dynamic Input (14): Alias translated to odbc:DRIVER={ODBC Driver 17 for SQL Server};DATABASE=DataWarehouse;SERVER=MWSQL;Trusted_Connection=yes|||replaceme

Info: Dynamic Input (14): ODBC Driver version: 03.80

Dynamic Input (14) Error opening "SELECT * FROM "replaceme"": No Columns Returned.

Any idea what I am doing wrong? I've a sneaking suspicion I'm making a schoolboy error...? :D

Run SQL Query from .sql file.yxmd

CDunhill · Answer

I'm not getting much traction from this post (my bad) so I think I might re-state my requirements elsewhere - thank you.

CDunhill · Answer

More screen grabs:

Summarize output to [Query]

Dynamic Input config:

Unedited query in Dynamic Input:

CDunhill · Answer

Are you able to make it run with a .sql file of yours?