hi

I've got to extract some invoice headers and invoice lines and put the results in an excel sheet.

I was going to extract the headers into a tempdb table and then extract the invoice lines that go with those headers again into a tempdb table then put the whole lot into excel.

But I'm havinga problem with permissions that I may not be able to overcome.

Any idea on other ways I can handle sets of data between SSIS steps.

Basically I want to be sure that the invoice lines I extract match the headers.

Thanks