This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Requirement- I want to load the xml file directly into the column as an xml data type through ssis package. Please share the screenshot of each component to be used in the ssis and complete process. I referred internet and this community. Xml Source--> Import Colum--> Ole db destination this seems to be one of the solution, but please give complete step by step details on above requirement.
Hi @Kashish,
Check the answers in below thread to see if it is helpful.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @ZoeHui-MSFT Thanks for looking into it.
As per the below script. The xml file location needs to be on the sql server. But my requirement is xml file location is placed on some different path not on the server.
DECLARE @tbl TABLE (ID INT IDENTITY PRIMARY KEY, xmldata XML);
DECLARE @sql NVARCHAR(MAX)
, @fileName VARCHAR(255) = N'C:\test\BBPAYG.xml';
SET @sql = N'SELECT * FROM OPENROWSET (BULK ' + QUOTENAME(@fileName,NCHAR(39)) + ', SINGLE_BLOB) AS Tab(XmlDoc)';
INSERT INTO @tbl (xmldata)
EXEC sys.sp_executesql @sql;
-- test
SELECT * FROM @tbl;
Hi @ZoeHui-MSFT Thanks for looking into it. My requirement is i have 10 different xml located on different drive (not on server). And i want to load the 10 xmls directly into the single column of the table as an XML data type.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Kashish, A similar question was recently asked, and was answered on this forum here: Loading XML file into XML column using SSIS https://learn.microsoft.com/en-us/answers/questions/867243/loading-xml-file-into-xml-column-using-ssis