78 How to import multiple csv files into sql server | Import all CSV files from folder to sql server

How to import multiple csv files into sql server using ssis
Download the file\script used in the Video from below link

How to import multiple csv files into sql server using ssis
How do I import multiple CSV files into multiple tables in SSIS?
How do I import multiple CSV files into SQL Server?
How do I import multiple text files into SQL Server using SSIS?

Happy Learning.

[nanaopp]

Hello Sir, why am I not getting the Using Microsoft.VB.FileIO option when I hoover over the TextFileParser?. Please how do I resolve this?. Thanks

[kevinshea]

I need to truncate the data from table before sqlbulkcopy. can you advise how to do that in your script? Thanks.

[karthikkunala]

Hello Aquil,

I have 100's of CSV files and I need to load to SQL Server. I don't want to create the table structure manually and want SSIS to detect and create dynamically. How to do that? In your first step you are creating the table structure manually, I want to avoid that.

[lamiaaelammari]

Thank you very much on this video, but really, I would like to have an example of upsert on this with the use of the temporary table and the configuration of variable and connection string made by a config.xml file
you can make us a demonstration how to do for the case of upsert in ssis but with any type of file.csv and its corresponding table the objective not to open the IDE VS SSIS just, we make the configuration on xml file(config.xml) in which we can mention the csv file and the table with its columns and type
for information it is the files of Bigdata

[priyavishalkulkarni]

Hi,

I have imported one CSV into SQL and then created an SSIS package.
To avoid repetition of data, I have used the Drop and Create commands in Execute SQL Task.
Everything worked fine till this.

After that, I want to import multiple CSV files with the same structure. For that, I have used foreach loop container.
Now the package is executing successfully but the data is not there.

[phumeleledlamini]

I got an error on this line "Dts.TaskResult = (int)ScriptResults.Success;",
saying "The name 'identifier' does not exist in the current context",
error code = CS0103

please help

[dellboysnr]

Where is the script that you used above in the list that you can download please, what number script is it?

[nzpkdyu]

Hi Aqil How to add dynamic columns to a table based on incoming CSV files ?

[sagarmore]

Hello sir.Nice video... but it will only work when you know csv file name and database table name is same. but if the file name is different and database table name is dirrent then how can we relate table and csv file?

[diyasmemories]

Hi sir I just opted the code and while running I am facing the decimal conversion issue . Any conversion can be done at code level

[diyasmemories]

Hi sir,

I need to insert data into 100 unique tables for which the files will be present in a single folder and all having unique column headers . How to handle this one.

[darbardarbar]

Sir without using c# no have any other way