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