Database insert from CSV files


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.



Yes, because if that column is primary key, then it will be error.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.