SSIS Data Flow Components for Salesforce fail when package is executed from command line
Posted: Wed 21 Sep 2016 14:44
I have developed an SSIS package using SSIS Data Flow Components for Salesforce. It runs in Visual Studio. When run from the command line using dtexec, there are errors.
What configuration is necessary for Data Flow components to run outside of Visual Studio? Note that Visual Studio may not be installed on the run time platform.
Thank you.
Regards,
John
Devart SSIS Data Flow Components v1.5.283 (Salesforce)
Code: Select all
Started: 10:38:13 AM
Error: 2016-09-21 10:38:13.85
Code: 0xC00490F7
Source: Data Flow Task Data Flow Task (Lookup [109])
Description: The managed pipeline component "Devart.SSIS.Salesforce.SalesforceLookup, Devart.SSIS.Salesforce.130, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701" could not be loaded. The exception was: Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified..
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC0047067
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: The "Lookup" failed to cache the component metadata object and returned error code 0x80131600.
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC0047076
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: Component Lookup, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D} failed to initialize due to error 0xC0047067 "The "%1" failed to cache the component metadata object and returned error code 0x%2!8.8X!.".
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC0048021
Source: Data Flow Task Data Flow Task (Lookup [109])
Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC004801F
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: The component metadata for "Lookup" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC00490F7
Source: Data Flow Task Data Flow Task (Salesforce Destination [166])
Description: The managed pipeline component "Devart.SSIS.Salesforce.SalesforceDestination, Devart.SSIS.Salesforce.130, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701" could not be loaded. The exception was: Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified..
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC0047067
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: The "Salesforce Destination" failed to cache the component metadata object and returned error code 0x80131600.
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC0047076
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: Component Salesforce Destination, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D} failed to initialize due to error 0xC0047067 "The "%1" failed to cache the component metadata object and returned error code 0x%2!8.8X!.".
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC0048021
Source: Data Flow Task Data Flow Task (Salesforce Destination [166])
Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
End Error
Error: 2016-09-21 10:38:13.85
Code: 0xC004801F
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: The component metadata for "Salesforce Destination" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
End Error
Error: 2016-09-21 10:38:13.86
Code: 0xC004801F
Source: Data Flow Task SSIS.Pipeline
Description: The component metadata for "Lookup, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
End Error
Error: 2016-09-21 10:38:13.86
Code: 0xC004801F
Source: Data Flow Task SSIS.Pipeline
Description: The component metadata for "Salesforce Destination, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
End Error
Info: 2016-09-21 10:38:13.86
Code: 0x4004300A
Source: Data Flow Task SSIS.Pipeline
Description: Validation phase is beginning.
End Info
Error: 2016-09-21 10:38:13.86
Code: 0xC001000E
Source: FIS to Salesforce
Description: The connection "{C336E1CB-63D5-42E0-9A01-FBB7528E80B2}" is not found. This error is thrown by Connections collection when the specific connection element is not found.
End Error
Error: 2016-09-21 10:38:13.86
Code: 0xC004800B
Source: Data Flow Task SSIS.Pipeline
Description: Cannot find the connection manager with ID "{C336E1CB-63D5-42E0-9A01-FBB7528E80B2}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "FIS Source.Connections[IDbConnection]" in the connection manager collection of "FIS Source". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.
End Error
Error: 2016-09-21 10:38:13.86
Code: 0xC0047017
Source: Data Flow Task SSIS.Pipeline
Description: FIS Source failed validation and returned error code 0xC004800B.
End Error
Error: 2016-09-21 10:38:13.86
Code: 0xC004700C
Source: Data Flow Task SSIS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2016-09-21 10:38:13.86
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Thank you.
Regards,
John
Devart SSIS Data Flow Components v1.5.283 (Salesforce)