I want to insert all CSV file rows into SQL database. I have exact same fields in both csv and database table. I setup database connection successful. I am struggling to process insert statement.
I am using for each activity to read each row and my SQL database name is “project” and table name is “dbo.dump”.
Can someone suggest what should be my query? specifically, I am not able to understand what should I write in Values in insert statement because I cannot use row.Item(0).ToString as value.
Please help and Thanks in advance.