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
Unkown Column in SQL Job Agent
Re: Unkown Column in SQL Job Agent
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?
2. Try adding the "Refresh Metadata = True;" option in your connection string. Does this help?