Post reply

missing records on output

  • November 15, 2011 at 10:33 am

    #144512

    Hi forum,

    I am creating a fact table with various tables and is not giving all records that i am suppose to have.

    i have an SSIS package that converts fields in a table to WSTR and STR.

    The number of records in are ok 21,381 but the number of record written to the output table are 21,212.

    how can i find out what records are missing or not being written to the output table?

    i added a conditional split to separate nulls in fileds that i know there are nulls and is not populating the table with nulls.

    Any help will be highly appreciated.

    Manuel Roman

  • November 15, 2011 at 2:18 pm

    #1408175

    What is the data source? If the source is a SQL Server table, is there a natural key you can use to do a outer join between your source table and the destination table?

  • November 15, 2011 at 2:29 pm

    #1408178

    That's what i am working on.

    i am trying to make sure there is a natural key if not assign a valid natural key for the lookups to work.

    Regards,

    Manuel Roman

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply