Skip to Content

SQL Query using in DI?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 09, 2016 at 05:24 PM

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

    Thanks,

    Denise

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 10:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 10:36 AM

    In Query transform:

    Map 1 to errorCode

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

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

    Add comment
    10|10000 characters needed characters exceeded