Importing csv file into SSMS #sql #sqlserver #ssms

32 thoughts on “Importing csv file into SSMS #sql #sqlserver #ssms”

• thank you so much for this video , helped so muvh

• Thank you. Very helpful

• you saved my time bro. I was looking for this all day

• Thank u very much

• Thank you very much sir .

• Bros. You just get another subscriber.. all the explanation from others, they give me errors..
  I'm using msql 2019 studio.. it's really hard to navigate. ❤😊

• Thank youuuu

• It doesnt show up the option SQL Server Native Client 1.0 How can I make It appear between options?

• This was very helpful to me
  Thank you so much , I am saved 😂

• Thank you, sir, you helped me out a lot it's been very stressful trying to solve this problem.

• THANK YOU!!

• super helpful, you're the best!

• Very helpful! I am going to interview for my first position as a supply chain analyst and the job is "sql focused." Small tips like this helps to review!

• My data has at least 30 thousand rows, it's been more than 10 minutes and it's still not over :c Is that normal?

• Extremely Helpful – Thank you sir!

• how to overcome with errors? Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Boxoffice" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
  (SQL Server Import and Export Wizard)

  Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Source – netflix-rotten-tomatoes-metacritic-imdb_csv.Outputs[Flat File Source Output].Columns[Boxoffice]" failed because error code 0xC0209084 occurred, and the error row disposition on "Source – netflix-rotten-tomatoes-metacritic-imdb_csv.Outputs[Flat File Source Output].Columns[Boxoffice]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
  (SQL Server Import and Export Wizard)

  Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "C:Usersvntu0DownloadsNetflix datanetflix-rotten-tomatoes-metacritic-imdb.csv" on data row 2.
  (SQL Server Import and Export Wizard)

  Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source – netflix-rotten-tomatoes-metacritic-imdb_csv returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
  (SQL Server Import and Export Wizard)

• Oh man, i would kiss you right now if i could. I had my whole sql learning curve stuck for months cause i was struggling to import data. Long story short, thank you very much.

• You don't know what you've done in my life. Thank you so much!

• how to import .rar file?

• Thank you sir. I spent hours in struggling with importing my file but this video just made it easier for me. Danko ❤️❤️

• Thank you so much ….very helpful

• Brother, how do I import txt file to Microsoft SQL server

• Thank you so much I ruined 2 hours for this and got a great video

• Thanks but I don't have a 'Tasks' option when I right click the table…

• Very clear. Thank you

• Thank you.

• Good video and great explantion. One question though. What happens when in your option of destination server, there isn't a SQL server Native Client. Which one ypu then choose. I'm still a beginner so I'm still getting used to this…Thank you

• Thankyou❤

• Finally, I visited the right channel to solve the problem

• I can't find SQL server native 😢any help for this problem?

• hi Taikup, Can you please make a video on WHY & WHEN we use EXCEL, SQL, R or PYTHON to complete a project.

• worked. I just had to search for my correct Destination at 4:31

Comments are closed.