Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cannot obtain the schema rowset "DBSCHEMA_COLUMNS"

Hi, I'm having this problem in a random basis. Let's say it happens 2 or 3 times each month. I have a scheduled job executing a SSIS package. This package calls many SP and sometimes it fails on a random SP returning the next error message:

Executing the query "exec dbo.Load_Account" failed with the following error:
"Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_PROD".
The provider supports the interface, but returns a failure code when it is used.".
Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Thanks in advance for your help.
1 person has
this problem