Flat file import gives Null value in destination table

  • I have two columns in a flat file that have 1's and 0's for data in both columns. SSIS is pulling both columns in as string [DT_STR] and the desination table columns are both [SCORECARD_ELIGIBLE] [varchar](50) NULL, [BR_SBRILESE] [varchar](50) NULL. When the import is complete I get the expected 1's and 0's in [SCORECARD_ELIGIBLE] but null's in [BR_SBRILESE]. Has anyone seen this before? Both columns have the same input data but one gets nulls and the other doesn't.

  • Found the problem. I missed the mapping for the input column for the one showing the null values.

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

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