Devart Forums

Hello,

I have an SSIS exporting tables from Salesforce DB to an SQL Data Warehouse. The data flow starts with a Devart Salesforce Connection Manager Source. Afterwards, I do some basic transformations and put the fields in the SQL destination. The package runs correctly in BIDS (Visual Studio), but when I run it in a job using the SQL Job Agent, it fails triggering the following error at source:

Description: System.InvalidOperationException: Unknown column 'xxxx'

Why is the package working fine in BIDS but then it fails when using the job?

Thanks in advanced

1. Are you running your package on the same workstation in both cases?
2. Try adding the "Refresh Metadata = True;" option in your connection string. Does this help?