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