Is there a way within VisualCron to load a file into a SQL table?
Specifically, I am looking to load a pipe delimited file without a header and double quotes as text qualifiers into a table. Ideally, I would be able to map the pipe delimited file by column number into specific named columns in the SQL table.
I am not looking for a way to load a file into a SQL table that requires the SQL server to be able to read the file due to restrictions by the DBA's. So, no BCP, BulkInsert, OpenRowSet etc.