Sorry, I should have been clearer in my original post. It is indeed a hierarchy in a self-referencing table.

If CONNECT BY will do the job then that's great news. Thanks...

Kevin,

The answer, as always, is "it depends".

An asynchronous component is generally used when the "shape" of the data is going to change.

For example, you want to aggregate the input columns...

Rowcount should work successfully. If I were you I would have an integer variable called "MyRowcount" that is populated by the RowCount component.

Then, have a string variable called "MyRowcount_str". In the...

Just in case anyone replies....

David,

I'm sold. I'll go out this weekend and buy those lightbulbs! I really will

-Jamie

I personally don't agree with the "eyesore" argument about wind turbines. A 250ft structure 5 miles out to sea is a magnificent sight to behold in my opinion!

The fact is...

A method which always works regardless of the provider is to build the whole SQL statement dynamically using expressions.

I always use that approach and so far...so good.

-Jamie

Hi Bill,

Yeah, that's the beauty of Virtual PC - always a good idea to install beta software on an image.

-Jamie

You get the SSIS designer with Standard edition.

You also get the imprt/export wizard as I said before.

-Jamie

Its not exactly the same, no, but Standard edition has more than enough to service the Import/Export wizard!

-Jamie

Cross-posting the reply as well

Try this: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx

-Jamie

Here's an example of something very very similar: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx

-Jamie

Thank you Peter. Much appreciated!

Is this a question about DTS or SSIS? It seems strange that you would post a quetion about DTS in this forum that's all.

-Jamie

At the time of reading "Conditional Split" was the top answer given so maybe I should provide a bit more explanation.

"Conditional Split" sends each row to a differrent output depending...