SISS _SRC Schema Builder Failure (System.NullReferenceException)

Symptom
SSIS package will fail on "Job failed Step 1 Query", usually when try to do cube to cube feeds in using SSIS engine.

The application event viewer will show the following SQLISPackage100 error (excerpt):
System.NullReferenceException: Object reference not set to an instance of an object...
Source Name: _SRC Schema Builder

This problem is due to the way SQL data types of smallint and tinyint are handled in early versions of the BPMC_ETL_Engine (v1.1.1-1.1.7) . For example, the [source] column of every fact table is defined as tinyint, so by doing a "select * from tblfactfinance" will evoke the error.

As a workaround, you need to cast any SQL datatypes as tinyint or smallint to "int"

Solution
This has been solved in BPMC_ETL_Engine_v1.1.8 and above and is included in the cumulative 112 Pack for BPM Connect.