0

I have a requirement where we need to import data from a .csv file to SQL server by creating the table dynamically. The reason for dynamic table creation is because the .csv file will have columns changing. We have to drop the existing table & recreate a new table based on the header information in the .csv file. (user may be running some diagnostic queries on that table later on)

I'm using C#.net MVC-3 & SQL Server 2014 standard version.Please let me know the best possible ways of achieving this.

Thank you.

Siva Dasari
  • 1,059
  • 2
  • 19
  • 40
  • I don't think you are using the right tools. Check this question out. It might help. http://stackoverflow.com/questions/8831060/import-most-recent-csv-file-to-sql-server-in-ssis – Brian Feb 28 '17 at 20:45
  • Does the CSV file contain a header row? Some information is needed to name the columns. – SteveD Mar 01 '17 at 16:49
  • yes, it does. The .csv file is generated by executing a standard perfmon job on any windows machine. – Siva Dasari Mar 01 '17 at 18:02

0 Answers0