I am testing a loop dataset automation task where I pull Id numbers that are strings from a .csv file and search for them in a database. In the database they are also defined as strings. Because they are numeric I'm getting an error:
File_1 - Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.
This seems to similar to this issue:
I've tried CONVERT(VARCHAR, :myVariable) but then the query hangs. myVariable is already a Varchar so this should not be necessary.
Any help is appreciated.