Thanks for the article.

Even though it seems very straight forward & simple , it really isnt because the XML source adapter does not always function as you would want it...

Thank you for the article. This function has always thrown me off on SQL server.

I dreaded dates before this! Thanks again.

Hi kyu,

I wasn't able to insert it thru the SSIS XML source adapter.

I think the lutz solution is very nice and worked great for me. Its very flexible and...

Great, Thanks.

I actually used SSIS to rename it to a static name. I will now use your script to run the imports!

Thank you!

S

Matt,

I was able to import the XML at the very simple level. But it seems very tedious to define multiple XSDs for each level as my XML file is very...

Matt,

Thank you for the tip. I will go ahead and try to do the same.

Lutz,

In your query like below:

DECLARE @xml XML

SET @xml = (SELECT * FROM OPENROWSET(BULK 'c:\filepath\variablefileName', SINGLE_BLOB)...

Hello Matt,

Im not sure how you pulled it off so easily? Did you have an xml with multiple nested elements?

What exact steps did you take? I would be interested...

Thank you so much Wayne.

Yes I am very tired, I have invested alot of time trying to figure this out so was making silly mistakes.

I guess I am really burned out. So sorry but it was such a dumb mistake.

I am now able to pull up all columns from the parent elements. I had...

Okay I was able to INSERT it by adding an INSERT INTO tblName (Columns....) right before the SELECT clause.

Lutz, can you please tell me how I can add columns...

hey Lutz,

I think this is the right direction. Firstly, could I integrate this into a SQL task on SSIS and run it? Also, I think you are just running SELECT...

Let me try it out.. thanks.

I want to automate this so thus the SSIS choice. But I'm sure I could use SQL task within SSIS to do xQuery right?

Below is xml file snippet:

<?xml version="1.0" encoding="UTF-8"?>

<Feed...

Yes, I put the data viewer and I dont see anything in the data viewer either.

I'm not sure why it's not grabbing the data from the XML file. I have...

Phil,

Have you done an XML import into SQL Server? I honestly did not think it would be such a pain!

I have almost explored all options. This is now getting beyond...