Padraig FItzgerald (10/27/2010)
Hi, I had the same problem and found a different solution. Posting it here in case it helps someone else out...Dev Environment BIDS 2008 on Win 7 64 Bit. Source: Oracle 10 DB. Dest :SQL2000 DB x86.
I was getting the error mentioned here and tried the various solutions posted.
None worked but i found that going to Project-->Properties and setting the 'Run64BitRuntime' to 'false' worked.
cheers
Padraig
Thanks , It worked for me too.