January 30, 2009 at 5:03 am
It’s a strange thing that happens every now and then, when im doing
big loads with SSIS, not all the records that should be pulled
through get pulled, has anyone had this problem before. I thought at
first it might because the dimensions were not updated properly but
that’s not true, 30 000 records did not pull through last night, I ran
the same package again this morning and every thing comes through.. I
am at my end with this because its happening regularly, its erratic,
im just wondering if anyone else has experienced this?
January 30, 2009 at 6:40 am
You haven't really posted much information here.
What type of data source are the records coming from?
Are the records being dropped in the source, destination, or lost in one of the transformations?
What transformations are you using?
What type of destination are you using?
Do you have logging enabled?
What do the logs say?
January 30, 2009 at 11:36 am
Perhaps you could grab a query plan and evaluate at night what you plan on pulling over. Sounds wierd but i agree more info would be helpful.
John Zacharkan
January 30, 2009 at 1:32 pm
Do you have precedence constraints on your dimension tables to load and process prior to loading the data into your fact table?
There has to be something where the data is not completely loaded in the dimensions prior to the query starting on your fact.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply