32 Import xml file to sql server using sql query

preview_player
Показать описание
Import xml file to sql server using sql query
Download the file\script used in the Video from below link

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?

Рекомендации по теме
Комментарии
Автор

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

prodbyZEKI
Автор

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?

protonefri
Автор

Thanks bhaiyya. I have learned new one

sureshareti
Автор

Love your video.. exactly what I needed

erickscribani
Автор

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.

hasanmougharbel
Автор

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

lakshmanachandana
Автор

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

FilipposSdralias
Автор

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.

mocanada
Автор

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

pvarunkumar
Автор

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

pvarunkumar
Автор

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

ananyamenon
Автор

Please make sql performance tuning scenario

tomedia
Автор

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

amruthacv