ETL : rows with Errors

I'm using a "Execute SQL Task" to run a stored procedure to populate a Fact table in our dimensional datawarehouse. There is one row which violates a foreign key constraint, which causes the entire task to fail so zero rows are loaded. Is there any way to grab the offending row and send it off to some holding ground and go ahead and load the rest of the rows.

I'm using Execute SQL Task mostly because I am very comfortable with writing SQL whereas the rest of SSIS is a bit unfamiliar to me, but I'm guessing that to handle error rows I might have to change to a different kind of task ?

Thanks

Richard

The best way to do this is to use a lookup in the dataflow to determine if the incoming record violates foreign key rules.

As far as your stored procedure goes, head over to the Transact-SQL forum for help with that.

errors processing cube

i'm facing some difficulties in trying to process a 3 dimensional cube.
Everytime i try to process this cube it'll complain that "A member with key
"(something)" was found in the fact table but not found in the level
(dimension level's name) of the dimension (dimension name)
anyone got similar experience in this? i've check that the fact table ids
are all present in the dimension tables... what could be wrong? please
help...
You need to reprocess your dimension. When a dimension is processed the data
in it is stored in a different data structure independent of the actual
dimension tables, and additions to the dimension tables won't be included in
the dimension unless you process it again.
Jacco Schalkwijk
SQL Server MVP
"Nestor" <n3570r@.yahoo.com> wrote in message
news:ODIW9DN9EHA.2788@.TK2MSFTNGP15.phx.gbl...
> i'm facing some difficulties in trying to process a 3 dimensional cube.
> Everytime i try to process this cube it'll complain that "A member with
> key "(something)" was found in the fact table but not found in the level
> (dimension level's name) of the dimension (dimension name)
> anyone got similar experience in this? i've check that the fact table ids
> are all present in the dimension tables... what could be wrong? please
> help...
>

errors processing cube

i'm facing some difficulties in trying to process a 3 dimensional cube.
Everytime i try to process this cube it'll complain that "A member with key
"(something)" was found in the fact table but not found in the level
(dimension level's name) of the dimension (dimension name)
anyone got similar experience in this? i've check that the fact table ids
are all present in the dimension tables... what could be wrong? please
help...You need to reprocess your dimension. When a dimension is processed the data
in it is stored in a different data structure independent of the actual
dimension tables, and additions to the dimension tables won't be included in
the dimension unless you process it again.
Jacco Schalkwijk
SQL Server MVP
"Nestor" <n3570r@.yahoo.com> wrote in message
news:ODIW9DN9EHA.2788@.TK2MSFTNGP15.phx.gbl...
> i'm facing some difficulties in trying to process a 3 dimensional cube.
> Everytime i try to process this cube it'll complain that "A member with
> key "(something)" was found in the fact table but not found in the level
> (dimension level's name) of the dimension (dimension name)
> anyone got similar experience in this? i've check that the fact table ids
> are all present in the dimension tables... what could be wrong? please
> help...
>