Database insert from CSV files

Help Activities
, ,
1

Hello,

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.

Thanks,

Tim

2

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

Yes

3

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