thx for your help remi.

Helps to have someone to bounce ideas off of.

no I did a right click drag drop to make sure I got every column and then got the copy/paste skills going on it.

I don't think it's possible the...

I actually used a DTS package and copied the normal query to the normal table, then removed the Costcode join condition on the source query and changed the destination table...

well to simplfy your suggestions. I have both results stored in physical tables, so I only have table A and Table B with the same schemas. I need to find...

Bah, I was hoping to be introduced to a magic wand of some sort. Apparantly Oracle's minus function is what I was looking for. Oh well. I'll play and post...

well at this point I have the result set for both queries in saved in physical tables. called ct and noCT. I need to get the rows that exist in...

how would that work syntatically?

select col1,col2,...,col n from table A

where col1 not in (Select col1 from table B)

and col2 not in (select col2 from table B)

...

and coln not in...

FC would work,but that would be an enormous text file. I'll start working on it to see where I end up.

yes... it's a data audit for a fact table build. Apparantly the "Period Budgets" do not rely on costtype to join with the actual costs, but I won't provide this...

It happens to me only for that server. I have other SQL instances where the db load time is far less with more databases.

Yes

Yeah it's kind of hidden. You have to right click Data Transformation Services and go to properties from the enterprise manager window to enable Multi-Phase Data pump to even...

Well I deleted all the other transformations  which are not simply copy columns and guess what, it's working now. I didn't think a seperate transformation would affect it but it's...

Hey guys thanks for the help but still it will not work. My destination is of type datetime and I've modified the script to the following below, but still only...

I've gotten to the point of typing my questions in notepad and then submitting them.