November 22, 2012 at 9:36 am
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
November 26, 2012 at 2:13 pm
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.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 28, 2012 at 5:31 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply