So I am by no means good at wtiting T-SQL or optimizing the code. But, Yesterday one of our devs called me and said that he had a SSIS job that was running i about 45 minutes start taking 10 hours. Ouch that can not be good I said. I asked him what tables were involved and I opened up my Professioanl SQL Serveer 2008 Internals and Troubleshooting and found a DMV that would show missing indexes. After taking a look at that I found that if I created three indexes on the table that the dev was joining on I might be better off. I created the three indexes and asked him to run the job again. What do you know, the job was back down to the time expected. All I can say is thank you SQL Server for being smart enough to tell me what to do.