Missing members in a table.

Question

Missing members in a table.

rajkarra91

Grasshopper

Points: 23
More actions
November 12, 2014 at 8:09 am

#295005

140 members who are missing from table. While loading the data into the table, the members are missing. The cause of the missing members needs to be determind and corrected.

Viewing 9 posts - 1 through 8 (of 8 total)

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

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

rajkarra91 (11/12/2014)
140 members who are missing from table. While loading the data into the table, the members are missing. The cause of the missing members needs to be determind and corrected.

not enough info I am afraid.....perhaps if you start with a more detailed explanation of what and how you are loading the data and the source and destination definitions will help

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

rajkarra91 Grasshopper Points: 23 More actions · Answer 2

Its a flat file data coming from client and loading tha data into a table in database..

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

rajkarra91 (11/12/2014)
Its a flat file data coming from client and loading tha data into a table in database..

ok...so pls provide flatfile structure and delimiters, the table definition of the destintation, and how you are importing (import wizard/SSIS/ etc)

cheers

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Eric M Russell SSC Guru Points: 125561 More actions · Answer 4

Using a text editor like NotePad++, isolate one of the records that didn't insert, compare it to other records that did, and see if there is a pattern in the data.

If you're using SSIS to load the file, then investigate if it has a Conditional Split dataflow task which might be rejecting records based on some condition. Also examine your slowly changing dimension related tasks.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Luis Cazares SSC Guru Points: 183706 More actions · Answer 5

You should use error files to identify those rows an understand why they're missing.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

rajkarra91 Grasshopper Points: 23 More actions · Answer 6

I m not talking about the code. My question is when i load flat file(members) into a table which is already created, i m unable to find 140 members in the table which i have loaded?

David Webb-CDS SSCoach Points: 17398 More actions · Answer 7

In order to help you find the issue, the folks here are going to need to know several things:

Definition of the table you are loading the data into, including any and all indexes and triggers

The process you are using to load the data

The process you are using to determine you are missing some members

Without that information, the folks here can only guess at what is happening. It's like saying 'I filled my car with gas but it won't start.' There's not nearly enough information to determine a cause for the issue.

And then again, I might be wrong ...
David Webb

MMartin1 One Orange Chip Points: 27795 More actions · Answer 8

Just to cover this, how did you conclude there are members missing? Does the process that moves the data from the flat file truncate the table before loading it (by any chance)?

----------------------------------------------------