Yes, I have...

About every hour

Sorry for the delay.

I don't have direct access to the real box so I had to get someone to check for me...

Nop, it's not an AMD, it's an Intel chip...

I must admit that 150 columns sounds bizarre but that's because the end user wants that data as a crosstab table.

I do a kind of pivot dynamically. There are not...

Thanks 🙂

I am not too sure how much does that mean but if I look at My Computer Properties from within the virtual machine, it says Intel Xeon...

From within a virtual...

Like a few others, I got it right a bit by chance by looking at the number of dots.

Frankly, do we need such a complicated statement to learn something?

I don't...

Not sure if that matters but I assign the file name of the child package dynamically based on data retrieved in a database.

Could that bother the debugger?

I can still see...

Elaine,

Have you made any progress on this?

I have a similar/simpler problem.

In my case, it does not seem to stop on any breakpoint in the sub package while it stops on...

How terrible this question was...

I just could not bear trying to work that one out.

Far too long and unreadable.

If anything we learned that "simpler is better".

Unfortunately, we all knew it...

Nice!

Thank You 😉

Nop, still there

http://www.sqldev.org/

There's an "interesting" url at the bottom: http://www.miibeian.gov.cn/

Looks like "voice of the people" sort of web site...

Cool, I could say to my grand kids: once upon a...

Good idea, I did not think about this...

Here is the vba code

I initially had a reference to the Excel Libraries because it makes the code "cleaner" by using early binding...

Just for the record, my final solution has been to instantiate Excel through VBA and send the result of my ADO request, hence a recordset, straight to excel.

This seems to...

Thanks

I saw a piece of VBA code starting excel and sending an ADO recordset to it.

It does the job for me perfectly because I can create the recordset the way...

I like that one indeed (the left outer join)!

Cool...:Wow: