Tag Archives: Oracle

Fix – SSIS to Oracle connectivity issue during run time (Error code: 0x8007007E/0xC0202009)

SSIS package started failing when I execute the package though all validations are successful. The failure was related to oracle connection failure. Fix: I had to change the package to Execute in 32 bit to fix the connectivity failure. Change … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , , | 3 Comments

Querying oracle database for the first time

I have been using SQL for a decade but I never had to connect Oracle database till last week! So, even basics are like learning for me! • Oracle SQL Developer is the tool similar to SSMS you can download … Continue reading

Posted in Productivity, Useful Link | Tagged , , | Leave a comment