Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Flat file import gives Null value in destination table Expand / Collapse
Author
Message
Posted Friday, May 10, 2013 7:12 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:48 PM
Points: 135, Visits: 286
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.
Post #1451572
Posted Friday, May 10, 2013 7:56 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:48 PM
Points: 135, Visits: 286
Found the problem. I missed the mapping for the input column for the one showing the null values.
Post #1451604
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse