Unkown Column in SQL Job Agent

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
Post Reply
ferran.salcedo
Posts: 1
Joined: Thu 26 Feb 2015 07:51

Unkown Column in SQL Job Agent

Post by ferran.salcedo » Thu 26 Feb 2015 08:03

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Unkown Column in SQL Job Agent

Post by Shalex » Tue 03 Mar 2015 11:03

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?

Post Reply