I’m creating a sequence that loads CSV files into a SQL database. I’m getting syntax errors with the Insert activity. A few questions I have:
Could blank spaces in the CSV header names be causing the issue?
Do the Columns names need to match between the SQL table and CSV file? I can’t control the CSV header names but could alter them with an activity.
Can the insert activity handle 250K rows of data?
Any information would be greatly appreciated.