Skip to Content
0

SQL Query using in DI?

Nov 09, 2016 at 04:42 PM

53

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Denise Meyer
Nov 09, 2016 at 05:24 PM
1

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

Thanks,

Denise

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Nov 18, 2016 at 10:50 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Dirk Venken
Nov 18, 2016 at 10:36 AM
0

In Query transform:

Map 1 to errorCode

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

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

Share
10 |10000 characters needed characters left characters exceeded