06 Import csv file to sql server using SSIS | Load CSV File in SSIS

I am having issue in connecting server on OLE DB Destination what to do anyone

Thank you so much for this informative video! Is there a way to import a CSV file on a different server such as an AWS server? In that case I assume the flat file connection cannot be used?

is it same as Using Bulk Insert Task ? and which options should be used in which case.

Hello, I am stuck with an import issue and was hoping someone here knows how to solve for it. We are getting csv file in different encoding 1252 and 65001 and if i use flat file connection i can only pick one or other encoding. Is there a way to pre-process all incoming csv files and save them in standard encoding before it gets loaded to the SQL server DB?

------------------------------

Test connection failed because of an error in initializing provider. The 'SQLNCLI11' provider is not registered on the local machine.
Showing this error when i click on Test connection

Hi Akhil,i'm learning a lot with your videos i really apreciate it! I have one questioin, is it possible to use the same connection to import csv and txt files? or i need to create a different connection for each one? TKS.

I'm unable to find the data tools in my machine even though I followed all the steps that was shown in the previous videos. Can anyone help on it.

ofter loading course in ssis sucessfully but in sql server if select * from course ,table giving result as NULL valus,what is reason pls let me know

Thank you sir for this video. It helps me alot thank you very much.stay safe sir stay happy

Bro I am getting an error of unicode conversion.
suggest me a solution

Hi sir, it's really nice.....
I have one doubt...

We checked the data is loaded or not into the table by using SQL SERVER
Is there any chance will check in Visual Studio....

Deep explaination thank you sir

Sir today I had an interview, and some question I failed to answer.

First Question: I've a CSV file(column ID, Name,Address) and same table structure in SQL Server table, but here in address column I want to ignore any comma. So how do you acheive it.

Second Question: In Packages where config file resides:

Third Question: If package is running slow then how will you fix it

Fourth Question: Does Lookup finds all matching instance or only one? Like in sql server table column ID and State, and ID is two times but state is different(like ID: 101,101 State: UP, MP). so explain if you're trying to load Text file into sql server then Lookup will give all matching in SQL Server table or only first match will tell you(This question I was not so clear little bit).

Idi telugu lo videos cheyyachu ga please

Hi Akhil, There is no SSIS database in my SSMS.
How to fix this ?
Waiting for your help .

Hi Akhil. Thanks a lot once again. I have been following your videos continuously as it helps me to learn ssis. I facing an issue while loading a csv file. I have a simple csv file, so when I load that and run the package I got an error like:
" [Flat File Source 1 [12]] Error: The column delimiter for column "Closing Balance" was not found.

".
Closing Balance is the last column. However I've searched for this issue but not get any result. Could you please guide me where I am getting wrong.

This is a great stuff you're doing. My only problem is that you're fast. But thanks for this free information

helpful ty u just saved me

Lucid Explanation

Sir i am trying to import a csv file through ssis but unable to do so, the file manager is unable to recognize the columns in the file, the csv file is exported from a system and I have to load it into SQL server.

Simple and helpful, thanks!

Aqil, bro you are a boss! Thanks for the tutorials

I loaded the csv file to ole db destination can it run successfully but when i check on sql server i find 0 rows on the table??

Thank you so much. Very useful. :-)

thanks. very usefull video.

Hi - very helpful video but having one issue. After I created and configured the connections and mapping getting an error that you cannot covert a Unicode to a non-Unicode column. My source is a .csv and my table column is varchar(50). I’ve researched and haven’t found a solution. Any suggestions? Thanks

Hello sir, Need your help here. I want data from different source like Oracle, netija and cms to one database using SSIS. Can you please help me.

Hi, I am new to ssis. Is unix scripting required for ssis?

Thanks - very helpful!

If I want to export data from multiple servers into single CSV file data is getting overwritten .can you please suggest how we can avoid overwritting the data

excellent

Hi Sir,
I liked your videos and all are very helpful.
Sir, please provide the video for how to load data from single csv file to multiple SQL server tables using some logics apply on the csv file itself.

Is it not required to change the data type to match the database table column data types?

sir, please provide the files which are used in this video class it will help a lot for practicing

Thank you! It was very helpful

How to deal with commas in comma delimited file when importing flat file as a source to SQL Server in SSIS
?

U r explaining as we are already know each n evey thing plz explain it properly

Giving error as file is already open by another process

Very helpful tuts, thanks a lot.

Hi can you please upload videos on SSAS

Great!!!