• Can you connect to source and destination in BIDS/SSDT?

    Are you running 32 bit or 64 bit SQL Server? If 64 bit, have you installed 32 and/or 64 bit Oracle Client?