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

SSIS Package not importing particular rows to sql server Expand / Collapse
Author
Message
Posted Thursday, November 22, 2012 9:36 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, August 23, 2014 4:05 AM
Points: 112, Visits: 1,480
I have a package that imports CSV files into SQL server, however certain rows are not importing. As soon as it hits a row with a particular empty field (product number) e.g. 1785 , that particular row doesnt import. So anything after the first four rows are not importing. Any ideas on what this may not be working?


15/11/2012 | REC | 1000 | 3157004D | 28/02/2015 | 0000100 | S005 | ACTO/030 | RECL
15/11/2012 | REC | 1000 | 3166010A | 30/09/2014 | 0001036 | S005 | ACTO/045 | RECL
15/11/2012 | REC | 3000 | GND099A | 30/04/2015 | 0002200 | S005 | ALVE/160 | RECL
15/11/2012 | REC | 655 | GNB212F | 28/02/2015 | 0002201 | S005 | | RECL
15/11/2012 | REC | 1785 | | | 0001281 | S033 | CALD/150 | RECL
15/11/2012 | REC | 1540 | | | 0001281 | S033 | CALD/150 | RECL
15/11/2012 | REC | 1637 | | | 0001281 | S033 | CALD/150 | RECL
15/11/2012 | REC | 2492 | | | 0001281 | S033 | CALD/150 | RECL
15/11/2012 | REC | 1529 | | | 0001281 | S033 | CALD/150 | RECL
Post #1387938
Posted Monday, November 26, 2012 2:13 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:18 PM
Points: 6,250, Visits: 7,409
Long list of reasons, anything from the target field in the table being defined as NOT NULL to row redirection in your components. Use the dataviewer on the dataflow pathing and see exactly when those rows fall out, that will help you narrow down to which exact component is causing the issue. Then check the error conditions for that component and see what it does on failures.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1388845
Posted Wednesday, November 28, 2012 5:31 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, August 23, 2014 4:05 AM
Points: 112, Visits: 1,480
I actually figured this one issue out. If you right click on the Flat File Source in the data flow task, there is a tick box with the info:

Retain null values from the source as null values in the data flow.

If you select this data with Null values are then imported



Post #1389664
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse