sorry bud that time of the day for me 🙁

anyway, i beleive its something to do with memory.

Also remember BIDS runs 32bit and not 64bit

the numbers :hehe:

well thanks for the help!

100%, but as i said, i would rather not make changes to sql system files. Apart from this, is there any other way to fix?

hi, if you suggesting SP's, i have already bolted on the lastest...any other thoughts?

point taken! thanks!

well personally if i have a text file which does not change in format, i use SSMS and save the wizard.

remeber there is no better method to another, it...

cool, my advise, flush the DNS of Server A and B and use the fully qualified name.

in my experice i would rather not use any wizards (they usually tend to be slow), rather go the route of BCP.

http://msdn.microsoft.com/en-us/library/aa337544.aspx

are these two instances on the same domain?

Hey, well I guess that's because every BI server is different. Some will make use of high logical calculations on the server while other's will pull calculated data from sources....

thanks all!!!

This is my problem exactly! thanks bud!!!

Well execution plan seems to be using a "hash match(inner join)", do you know anything about this?

although i don't see any #tables?

-thanks for this, i am reading up on the lock pages thing 🙂

-VM performance, yes, DW should never be run on a VM, problem is, that business has already bought...