Losing SSIS database connection to Oracle

1071585 pts.
Tags:
Oracle
SSIS
Our SSIS package takes data from an Oracle view, transforms it and then loads it into a SQL Server table. Our database source / destination is all set (connected at least). But we keep getting this error message:
Data Flow Task: ADO NET Destination has failed to acquire the connection {046C4CA9-2BBF-46FD-9FEA-06F1B173BB35}. The connection may have been corrupted.
So what should we do here?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Reset your password or try to login again

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: