Challlengebrains.blogspot.com Website Review

in my last article, i talked about how you can use an  ftp task in ssis to do*nload files from an ftp server. but what if the file you there are different ways to achieve this task of importing data from an xml file into a sql server table, but i am going to demonstrate one of easiest ways to accomplish this task. these are the steps i performed for importing data into sql server i have an xml file do*nloaded from my ftp location to a local folder and data in this xml file looks like this: server, i am using the openrowset function as you can see below. in the script below, i am first creating a table with a column of data type xml and then reading the xml data from the file using the openrowset function by specifying the file location and name of the insert into xmlwithopenxml(xmldata, loadeddatetime) select convert(xml, bulkcolumn) as bulkcolumn, getdate()  when i query the table in which i have imported the xml data, it looks like this. the xmldata column is an xml data type, it will clicking on the hyperlink, in the above image, will open another tab within ssms with the xml data displayed as shown below. now as i said before, xml data stored in a column of data type xml can be processed either by using xml functions available in sql data that it has prepared and stored in internal cache. then we will use the handle returned by from the above xml data, i want to retrieve all the customer information and hence i am navigating to the customer element and querying customerid and customername (please note the use of @ before the name of the attribute) attributes and address element in the above select statement using the openxml function. the structure of the resultset can be determined with the with from the above xml data, i now want to retrieve all the customer information along with orderid and orderdate placed by each individual