1999317 - Upgrade to Data Services 4.2 causes Lookup issues

During a migration from 12.2.3.5 to 4.2 SP01, many of Data Flows of the same kind failing execution.

The dataflow has four sources from two different schemasof the same database (FRED_MART). It has a normal join into a Query transformation. In this Query transformation a few lookups into another database and pull the necessary fields (in the format "Double") into the Querytransformation.

A few calculations based out of the lookup values extracted was done and the dataflow resulted in the following errors:

1. SQL submitted to ODBC data source <lonssqldev01> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

2. SQL submitted to ODBC data source <lonssqldev01> resulted in error <*****>. The SQL submitted is <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message,  ask your administrator to assign additional privileges to your account.

• Data Services from 12.2.3.5 (to ver. 4.2 SP01)
• Windows Server
• Database: SQL Server 2008

KBA , EIM-DS-EXE , Job Execution , Problem