What width do you have the report set to? What is the combined width of the 2 tables?

I think you'd find the FULL OUTER JOIN method I mentioned earlier may perform better, although you are not going to get optimal performance from any solution as long as...

I mean try both options and see which one works best. I just don't think the DataFlow task will work well because it is RBAR (although in memory) and...

Well, 1 if the values are identical, does it really matter which table it comes from? 2 - I was assuming and apparently incorrectly that SQL Server will use...

Do you mean you have either Domain\Login or Login in a table? Because that is what you will need.

I think the fastest way will be to Truncate then do Bulk Insert. The slowest would be TRUNCATE then data flow task as the data flow task does the...

I'd do explicit transactions and commit then you should be all set with the an error only rolling back the current transactions. You can do TRY CATCH in a...

You won't find a .DBC because you are dealing with FoxPro Free Tables not a FoxPro database (.DBC). The issue you are having is permissions accessing the network location....

You can do something like this to get the values into a table:

CREATE TABLE #temp (VALUE VARCHAR(100))

INSERT INTO #temp

(

VALUE

...

Can't disagree with that, as usual, Gail. I was just presenting another option, if the OP has to use 'Detailed'

I'd create a role and give it those rights on each schema in the database. It's not quite db_owner so I'd avoid that.

If you ALWAYS want the data from table 1 if it exists I believe you can just do a UNION because UNION eliminates duplicates and I believe it will take...

You'd have to have some way to match a user login to an employee. Do you have that information anywhere?

In most cases I have seen the recommendation is to use the 'Limited' value for sys.dm_db_index_physical_stats instead of 'Detailed'. 'Limited' returns just the Top level (0). So I'd...

In addition to what Chris has said, you also need to know that in the FROM you can have multiple tables JOIN'ed together, typically this is on a Foreign Key...