j_e_o (6/6/2012)

---

Go right ahead GSquared. How about "j_e_o doesn't know what he's talking about 'cause he's probably drunk"?...

Awesome!

And you're welcome.

j_e_o (6/6/2012)

---

This thread has been hijacked. Where are the authorities when you need them? 😀

By the way, when someone uses, :-D, they are making a light hearted jest and...

TravisDBA (6/6/2012)

---

Lynn Pettis (6/6/2012)

---

But it is. Here is the post where you said it:

TravisDBA (6/5/2012)

---

MdApache (6/5/2012)

---

People...

TravisDBA (6/6/2012)

---

Jeff, I wasn't referring to anyone being a "dillweed". I was referring to the secret society which he belonged to which could possibly explain his secretive and "covert" behavior....

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 with...

I think this will get you started:

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'' type=''abc'' direction=''outbound'' durationMinutes=''0.43'' token=''113ddd5999257543963a760789fc12344f27cb0bcc519f0ce6d3a907fccb0d56361c4e3151c3780c35c752cb'' bridged=''false'' callerId=''1234567890'' sessionId=''86c368af24d7eab2a84ec6660704f3d4'' connectionId=''0''>

<outboundDialString...

You might be able to skip SSIS altogether and just pull the data into a staging table by using OpenRowset. Simple import jobs can often be done that way.

Beyond...

richardm-1037631 (6/5/2012)

---

GSquared

Creativity != "that's how we always do it"

I would like to suggest a 3rd option to remember:

"that's how we always do it" != Reason to change

Just because something...

I have to plead guilty to being one of the "loud" people. But I do take measures to make sure all voices are heard, all viewpoints presented.

Two things I've...

Sounds like you're going about it the right way. How'd the index test go?

First, I doubt you'll get a response from the original poster on this. If you note the dates, the original conversation was 2 1/2 years ago (December 2009).

Second, output...

I've got a good job at a good company, and have to keep telling recruiters that I'm thankful they thought to bring opportunities to my attention but that I'm not...

patrickmcginnis59 (6/4/2012)

---

GSquared (6/4/2012)

---

I've maintained for years that databases are platform-portable in the same way that continental plates are "portable". They do move, and it's usually listed as a disaster...

rob.lobbe-964963 (5/31/2012)

---

Grant Fritchey (5/31/2012)

---

Alex-668179 (5/31/2012)

---

"every table within SQL Server should have a clustered index"

Fine, but should it then also always be the (preferably meaningless?) primary key? Or an index that...