Search This Blog

Tuesday, December 18, 2012

Bug: SSIS Engine 2012 Synchronize Issue

Sympton:
Feeds throw an error while running in synch mode. Error found in the SSIS Engine 304 pack.
Error is as follows: Job failed on data synchronize. Please reference SQLISPackage100 errors on the SQL server application event log more detail
 
Cause:
The SSIS Package tries to use a package variable (SSIS_Fact) that does not exist in the synch code section.
 
Error in Windows Event Log;
Event Name: OnError
Message: Exception has been thrown by the target of an invocation.
Operator: AM\xxxxxxxxx
Source Name: Bulk Load to Fact
Source ID: {2A08E54B-207C-4739-94BD-F0D90D8EB500}
Execution ID: {2D084DF6-F466-462E-86F0-CE017A190083}
 
Solution:
This has been solved in the following SQL Engines:
SQL 2012 BPMC_ETL_Engine_v2008.3.1.3
SQL 2012 BPMC_ETL_Engine_v2012.3.1.3

No comments:

Post a Comment