sturner (6/12/2012)

---

I don't understand why it would break anything to change the column data type of destination table to match that of source table. The numeric into a int...

David Webb-200187 (6/8/2012)

---

When I run the data you gave us above through the SQL I sent you, I get

the attached results. If this is correct, the the SQL...

Guys I am stuck..need your valuable inputs...Is anyone around?? 😀

Oops that doesnt work either... I apologize for making this thread grow big...but unionall doesnt help...it returns duplicate data as well. Is there a way that I can fix this...

David thanks for the reply..I havent tried that yet because I went through the route of SSIS as I needed to loop through a lot of files.

I think I...

FYI This is how my .xsd file looks. The ones that i have bolded are the columns I need.

<?xml version="1.0"?>

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="sessions">

<xs:complexType>

...

Thanks for your replies. I am able to generate an SSIS package that loops through all the XML files. The issue I have here is the XML source I am...

Yes...I just realized that..Thanks much

my query could definitely be wrong..

I have modified the query a bit per my requirement and it is as shown:

DECLARE @XML XML = '<?xml version="1.0" encoding="UTF-8"?>

<sessions accountId=''48152'' startDate=''2012-05-27'' startTime=''00:00:00'' endDate=''2012-05-28''

endTime=''00:00:00''>

<session applicationId=''357627'' applicationName=''app1'' startTime=''00:48:54'' startDate=''2012-05-27''

...

Is there a way that I can loop through if I have too many xml records?

Thanks again Gsquared I will definitely go through the route of SSIS.

Let us know when you get to questions you can't figure out on your own with searches...

GSquared (6/6/2012)

---

Sapen (6/5/2012)

---

Thanks for your valuable inputs everyone.

I apologize for not posting my question clearly. The xml file is not always a same file instead a new file gets created...

Thanks for your valuable inputs everyone.

I apologize for not posting my question clearly. The xml file is not always a same file instead a new file gets created with a...

Thanks a ton guys