Yes everything is setup correctly as if I just execute the send mail task it works but if I execute the entire package somehow the error handler never fires (even...

I am running SQL Server 2005 Standard Edition on the Server + all the tools except for the client tools.

On my workstation I installed Client Tools and SSIS for SQL...

Right, I figured out the SSIS errors in the log. It happens if you execute the package from SQl Management studio and don't have SSIS installed on your workstation...

I created a new package in the BI studio and imported it into SQL Server 2005 and executed the package and gave me some jaw dropping error messages.

OnError,,Safety_Logs,{C2D1039F-7B47-4219-8872-AA61DAD8CF34},{7527C3B9-8E4C-4C4B-BFAD-0064008A79B6},5/22/2008...

That helped. I did not realize I had to actually connect to the SSIS service. Thought it would have been all in one like in SQL Server 2000. ...

Thats the problem getting that 1 value from a table thats 1 to many is not possible. 

Take the simple query and say SELECT id, shippers, pickupdate, city,state, phonenum from...

Use DTS and in your situation you just might use the DTS wizard and save whatever information you want into a table.  Read up on DTS and it should be...

I have found a solution but I am not sure if this is a bad way of doing it.  I sense that I might be pulling too many records for...

You are correct on the relationship.  I am displaying all the shipper information and consignee information all in one row.  Look at my select statement carefully.  You will see that...

rhunt: No the shipper and consigneee tables are distinctly different.  They would never be duplicated information in either of those tables.  Distinct does not work for this anyway since I...

Thanks that is just what i needed, at least now its a lot easier to read and update and learned of a new way of how I could change some...

Yes I noticed that, but I figured that out without your help. :]

ALso your temp tables where messed up as well. Yes, you need a vacation. That...

Ahh I thought the first where statement was for the subquery and the 2nd where was for my original select, so I joined the 2 where's together and I am...

I reworked the join, though I think you meant the active_units table and not the active_units_static, I almost got it 100% sytaxally working with one error saying

Line 18: Incorrect...

Thanks for the idea, but it wont be any any faster, if anything it will be slower since there is more processing as the month and year are both static...