You've outdone yourself with this one Jeff. This article is fantastic. I guess the thing for me to remember, and the reason why some call it an unreliable hack, is...

Excellent! Thank you for pointing me in the right direction. This article does address all my concerns. I did a search on this great site, but I used search terms...

Thank you for your response.

The optimization in this case is negligible, but I do see your point. The downside to your script is that the dates are hard-coded, and one...

Hello Brian, et al,

Thank you for time in this article. It was very helpful.

For posterity's sake, I did want to point out what appears to be a small, but important,...

Very nice article. Thanks for sharing. My two cents are that I would use the dense_rank() function to return the rank in tandem order. The rank() function tends to skip...

As far as I know... yes! We use the exact same code for every XML file we import, of which there are like 8 - 10 different ones from several...

Hey Slick84, kyu.lee, et al,

We import XML files all the time using the XML Source adapter in SSIS. The trick is that before you import the data, one must first...

Unless I am missing something, I think what you said below would be your best bet... just return the IDs in the flow... not sure why they need to be...

No, it is just a string. I put varchar(10) due to force of habit... char(8) is fine, and better.

mstjean (7/21/2010)

---

Hi Sean,

I love the script! Did these get added?

...and for my...

Thank you, sir! Sorry, I didn't bother to check the script 😉

Hi Sean,

I love the script! Did these get added?

...and for my little (very little) contribution, I would add an ISO date field (e.g., 20091006)

convert(varchar(10), getdate(), 112)

Sean Smith-776614 (6/29/2010)

---

Quick FYI:

I've added...

If you are trying to make an existing column an identity field, the table has to be rebuilt (in other words, you essentially have to copy the data into a...

You can certainly use the RowVersion column for incremental loads, if you have it on the source, and you should not really need anything else. Although, I would recommend using...

Good script... appreciate the work.

One thing though, is that this script attempts to drop indexes for primary keys, which is not allowed explicitly. One has to drop the actual constraint.

Very good catch Jesse!

Jesse McLain (4/3/2009)

---

There's only one problem with the calculation of the median: if the row count of the sample data is even, then the median is not...