32 Import xml file to sql server using sql query

Import xml file to sql server using sql query
Download the file\script used in the Video from below link
drive.google.c...
Download and restore adventureworks database to SQL 2019: • 06 Download and restor...
SQL Server: • SQL Server
SQL Server Developer Interview questions: • SQL Server Questions
Import xml file to sql server using sql query
How read XML in SQL query?
How do I get data from XML format in SQL Server?
Can SQL read XML file?
How do I import XML data into SQL Server using SSIS?
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@erickscribani4025]

Love your video.. exactly what I needed

[@learnssis]

Thank you Eric.

[@sureshareti2843]

Thanks bhaiyya. I have learned new one

[@protonefri]

Hello, great video for beginners. I have a problem that all of my namespaces have prefixes like env:Invoice for example. so I am not sure how to get data with prefixes?

[@pvarunkumar8106]

I hv a task, from CSV (source) to SQL server (destination), i want to import up to some rows only.

[@learnssis]

If you have an Id or some primary key in your source csv file, then you can use a conditional split transformation and import only those records those lies in a particular condition like
Id > 100 && Id < 500
If you want to skip for example 500 records from csv file and want to load rest of the data then you can take a look at this video
th-cam.com/video/z_0ECBTo2ZI/w-d-xo.html

[@ananyamenon7397]

what do I do if my columns names in the xml is different from my column names in the table

[@learnssis]

Ananya, in that case you just need to modify the select query and provide the column names as per the column names in xml file.

[@pvarunkumar8106]

What does it mean, like, " An error occured while slipping data rows"

[@learnssis]

There should be more error information, it is one piece of error, it means you are trying to import some data from a source and SSIS is failing and unable to read the data due to some formatting issue in the source file.

[@FilipposSdralias]

Great tutorial! What if the encoding of the xml file is iso-8859-1?

[@learnssis]

I normally don't import the xml files a lot, load them rarely but if I am unable to load it using sql server, then I can try loading it using ssis or C# as well.
th-cam.com/video/9vWYLGsaXJc/w-d-xo.html
th-cam.com/video/bZAvgXE5awk/w-d-xo.html

[@hasanmougharbel8030]

Hey there, god bless your efforts in this channel.
I am new to sql learner and has a simple enquiry.
Is XML a file type like CSV or it is an integration tool?
Thanks for taking care of my enquiry.

[@learnssis]

Thank you. XML is very similar to HTML which is used for designing. XML is used for storing the data like we saw in this example that 1000 records were stored in a specific format in XML, so it is used for storing the data. It is also used for transportation of data, if you have worked with API or web services they give the result to you in XML format (some api or web service now give the result in JSON), so it is also used for data transportation as well. C# as well as SQL has many keywords and functions those are specially designed to work with XML directly.

[@hasanmougharbel8030]

@@learnssis great explanation thanks a lot

[@mocanada304]

Hi Aqil,
Thank you again for an amazing video.
Is there a way to create a stored procedure that can accept any number of parameters, like in python we can set any number of parameter such as ( def concatenate(**kwargs))?
I am thinking of creating a dynamic stored procedure where I do not need to enter all column names multiple times, instead pass them as a parameter while executing the stored procedure.

[@learnssis]

We can not pass the variable number of parameters to sql stored procedure, but we can pass a long string having multiple parameters separated by comma.
stackoverflow.com/questions/7462552/stored-procedure-with-variable-number-of-parameters#:~:text=yes...its%20something%20like,of%20this%20array%20can%20vary.

[@amruthacv2432]

Sir how to provide permission for the file to be accessed?

[@learnssis]

On the folder in which file is available, right click on that folder, go to properties, go to security, click edit, click on add, add your account\or everyone, tick on full control and modify, click apply, click Ok.

[@prodbyZEKI]

Great video, only one thing, you have to put the .xml file in the SAME server that you have the BD, perfcet video!

[@learnssis]

You are most welcome Cheese Studio.

[@7to7media]

Please make sql performance tuning scenario

[@learnssis]

Honestly speaking I am not very good on sql performance tuning. I am trying to learn the concepts and will share once I think I am good.

[@7to7media]

@@learnssis tq

[@LearnersPage]

Thank you ...

[@learnssis]

You are most welcome LearnersPage.

[@lakshmanachandana9099]

First of all thank you so much.. plz do video on same thing by using ssis task

[@learnssis]

We already have a video on loading xml file to sql server using SSIS
th-cam.com/video/9vWYLGsaXJc/w-d-xo.html

[@msahab9657]

Very good

[@learnssis]

ha ha.