FOR XML is an option to have the results of a query be formatted as an XML component. You'll find the description in Books Online for all the different...

Yeah, yeah, my favorite Luddite. 😛

Considering I...

Is 22Feb2012 the exact format? For single digit days, is it 01 or 1?

Two ways come to mind. Configuration for the variables, or run time settings when you call the SSIS executable via the command line. If you google up SSIS...

ScottPletcher (12/18/2013)

---

Yikes! Table values should be trimmed by a trigger once during insert/update if necessary rather than in every query afterward. If you really need to, you can...

Scott,

I'm not sure how that's more or less obscure, but it's certainly easier for me to read. I work with a lot of 'iffy' data in loaders, and a...

My pleasure. I'm pretty sure the problem comes down...

It's primarily used for heavy aggregation structures, such as warehouses. The problem is you can't update a table with that index attached, so it'd really only be useful on...

blasto_max (12/18/2013)

---

Evil Kraig F (12/18/2013)

---

You were trying to pass an object variable with a dataset in it to the child package, or something else? Need a little more detail...

You were trying to pass an object variable with a dataset in it to the child package, or something else? Need a little more detail about exactly what you're...

In general when looking at problems with these types of algorithms, it's helpful if you have a data sample complex enough to show the issue that we can poke at.

However,...

Offhand, I would recommend normalizing this data if you have any intentions of searching for groups or similar. The reason being group xyz could be in the 3rd, 4th,...

All of them, if you...

I've always written custom code and transformation script components with multiple outputs for things like this. I haven't heard of a tool with that much built into it (generically)....

Hey all, sorry I haven't been around for... well a good while. Merry Christmas to everyone, though!