SQL Query using in DI?

[former_member281308]

SELECT @errorCode = 1 , @errorMsg = @errorMsg + @Delimiter + 'Missing Date Processed'

FROM #tblStaging

WHERE NULLIF(DateProcessed,'') IS NULL

Above the SQL Statement How to use in Query Transform in DI?

[denise_meyer]

If this is connecting to a database table, you can use this in SQL transform as a source.

Thanks,

Denise

[former_member198401]

Hi

The above statement is using a Temporary table in SQL Server. only physical tables can be accessed in Query transform. I have never tried with accessing Temporary tables in datastore and then using it in Query Transform.

You may try using the above SQL in SQl transform.

As Dirk mentioned you can try the mapping.

Regards

Arun Sasi

[former_member187605]

In Query transform:

Map 1 to errorCode

Map errorMsg || Delimiter || 'Missing Date Processed' to errorMsg

And put nvl(DateProcessed,'') = '' in the Where-clause