SSIS Tutorial Part 57- How Null values match in Lookup Transformation

[@databasemsbi7727]

Finally, which catch should we use to include null value in matched output, it is partial and no catch choices. Full catch is always exclude null value or case sensitive output. right?

[@devexpost8508]

Aamir, Note that the documentation says _by default_ the OLE DB client issues a connection-level SET statement setting ANSI_NULLS to ON for the session when connecting to SQL Server... In the SSIS menu: Tools-> Options-> SQLServerTools-> Transact-SQLEditor-> QueryExecution-> ANSI there are options for “SET ANSI_NULLS” and “SET ANSI_NULL_DFLT_ON” which may permit alteration of the behavior for NULL to NULL comparison for Full, Partial, or No cache. Presumably the first will change the behavior of comparisons done in cache (Full Cache) and the second will change the connection level SET statement which is overriding the DB settings for comparisons done on the DB (Partial & No Cache)? Best Regards. .

[@danieljoubert7937]

Thanks as always.

[@manikantamokidi5631]

i have duplicate records in my table in my flatfile file i have take only one id column with one value only(ex:-5) when i do look up flat file to oledb only first record getting in that table remaining records are not getting can you resolve my problem sir