I am trying to create the attached project, which is a pretty simple CSV to SQl table ETL. I have a similar project that reads the data from a SQl view and works fine. In this case I needed to use a file as the source data. The file is multi-purpose and has more fields than I need so I thought I could just specify the column number in the rowset var. But I can't seem to get past a error on the SQl insert step.
8099 - Connect to Destination DB] An unexpected error occurred. Invalid cursor position: BEFORE_FIRST Original expression: data.
I've tried various things like putting quotes around the rowset column var but nothing seems to work. I'm pretty much a novice with GoAnywhere so I was wondering if someone could give me some guidance.