You can accomplish this with a ODBC drivers and the Insert Data activity in Workflow, however, the catch is that the file will need to reside on a drive/network drive mapped to the Workflow Server, you would need a static file name, and if it is anything like using ODBC for Excel files you will get an error if Workflow tries to access it while another user has it open.
- Make sure the necessary drivers are installed on your Workflow server
- Microsoft Access Text Driver for txt and csv files
- Microsoft Excel Driver for xls, xlsx, xlsm, or xlsb files
- Open ODBC Data Source Administrator (64-bit) on the Workflow server
- Open the System DSN Tab and click Add
- Choose the appropriate driver and click Finish
- Enter a name in description for your data source
- Uncheck "Use Current Directory"
- Click Select Directory
- Select the drive > folder > file
- Click OK > Click OK again
- In Workflow Admin or Workflow Designer
- Open the "Manage Data Sources" interface
- Click Add
- Enter a name/description and choose "Windows ODBC" and click Next
- Select the ODBC you created in Step 2 from the drop down for Data Source Driver
- Click Next > Finish (Windows Authentication should be selected by default)
Now the CSV file you designated will be available for use with the built-in Query, Insert, and Update activities inside of Workflow.