This fails, it looks for #interim table?

Along those lines we got it to work, there was a key change that needed to be made in the stored procedure and then use of your code. Thanks for...

I am in 2005

This is in a matrix so you can't add code to the subtotal line I thought?

Thanks so much, I knew I was close but the last post really cleared up how the STUFF function works!

Thanks for all your input, I too agree with having everything in a common DB but alas I just started here and this is what I have to work with...

Thanks for all the help.

I've attached the sample data.

After loading all the data you will see that Contact Ali Abounnaim is authorized in all accounts and has the highest...

Hey Lowell,

That worked great, I have never used stuff or an XML before, gives me something to learn! Thanks!

Hi Welsh, this helped immensely, thank you

That helps Ray! Thank you, I will look through the data and see whats up.

Hi Stewart,

Got the answers from our DBA...

Server is x64

SQL2008 software is x64

4gb of RAM

C has 16gb of free space, 50gb capacity

I am taking three tables from one DB on one...

Hi Stewart,

Thanks for this, I think I got this part down. Now how do I reference this variable in the Data Flow Task?

I set the variable in the SQL Task,...

We moved the DB to a larger server and it was working fine but now this error is rearing its ugly head!

Information: The buffer manager failed a memory allocation call...

Hey Tom,

Thanks for the reply, we had to move the server to another drive with more space and that resolved the issue.

Marty

Hey bgeige

This isn't working for me, I must be missing a step some where...

1. Add a new SQL Task to the Control Flow - OK

2. Change the Result Set...