I totally agree about the questions getting worse, but you have to understand this much...the more basic questions that are answered the more it could possibly help someone down the...

I thought you first said that there is no relationships between either table...in any case the first suggestion is correct in that it will give you a cartesian product. If...

I second your suggestion, totally go with a temp table, take a small sample size (if you can) of the 6.8 million rows so that you can see results quicker...good...

If you're going to do it right the first time you need to see if the jobs are all active, are they needed, are they split into categories. The jobs...

Gila is right on both fronts, key lookups only occur in that situation and all execution plans add up to 100%

The version i'm running is the one below:

Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition...

I solved the issue, it seems that running this line will always throw an error...

exec master..xp_cmdshell 'dtexec /f "D:\SSISPackages\TEST_REPORT.dtsx" /set "\package.variables[User::ReportID].Properties.Value";"95E56F3A-DBEF-4FA1-B3E9-92A4BCB15E42"'

But running it in this scrict form below always works...(weird?!?!)

set...

HAHA, you can just google the answer, I was just asking because you could have easily posted the answer...good point though 🙂

Please post how to select the tables belonging to a certain schema 🙂

Thanks for your reply, I figured out what the issue was. It has more to do with the admin rights that are here at my job which are f****d up...

hey colin, that would be great if you could send me that code. I would be most appreciative. Would you rather email it to me or post it in the...

Thanks for your help Syed, what you suggested as far as the ping worked, I also had an issue running the xp_cmdshell command on the server because it wasn't activated,...

Thanks syed, I have the IP of the server, I will just set up another step in the job where if the step succeeds then continue with the job and...

Ok Syed, I was just about to ask about that because I remember seeing something like that a while ago. I'll look into it now, do I need to have...

You think its possible for me to add that into SSIS or just create a whole new step in an agent job? I'll look up the diagnostic manager now because...