Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


josephin sebaraj
2024-11-05T21:39:27Z
Good evening,
Looking at the best way to load the CSV files into SQL server tables, I could not find the documentation. Please guide on it. Thank you.
I tried with Read file and then SQL task for insert, but I was unable to read more than one field from that file input. Thank you

Thank you.

Josephine
Sponsor
Forum information
thomas
2024-11-08T14:58:06Z
I yuo show what you have done it may be easier to see why you are getting one field from the file. Having sais that, looping over the file in VC and doing an insert for each row is going to be extremely slow for any file with even as little as 100 rows. I suggest you look into other ways of loading data from csv to sql server. Some options:

1) SSIS. It is free but takes time to setup and learn how to use
2) Bulk insert with openrowset. It is a way of querying a file directly as if it was a table. You can do an insert from there
3) Powershell/dbatools. Ex: https://docs.dbatools.io/Import-DbaCsv 
Scroll to Top