I found the solution, yippee,  it works perfectly.

http://www.sqlteam.com/item.asp?ItemID=2955

Thank you, I'll take a look.

Thanks for replying,  Can you tell me a little bit more (point me in the right direction) about how the dynamic query would interact with the pivot statement

Thanks, I'll read this as soon as I get home.  I'm headed out the door now.

Client computers are Windows XP Professional SP2

I'm not using SSL.  I am using Windows Authentication.

My reporting services is installed on a Windows Server 2003 box.

I'm using the reporting services interface, it's an internal report.  I'm not crossing any domains - report server is in the same domain as my computer.  I created the report and data...

Thanks for replying.  I am not using parameters.

From your DTS package.  Are you able to successfully run each of the steps individually, one at a time?

This is a long shot but check the Environment Variables under System Properties.  By default these are usually c:\temp and c:\tmp.  If your DTS process creates a temp file you should ensure...

Excellent, excellent, you are an awesome developer.