Showing posts with label retrieve. Show all posts
Showing posts with label retrieve. Show all posts

Wednesday, March 21, 2012

loop through a datagrid

Hi,
No I don't want to loop through my dataset ;) I want to loop through my
datagrid to retrieve the values in each cells, but I don't know how to
do that ?
Can someone help ?
thxNo idea - you'll probably get a better response in an ASP.NET group:

microsoft.public.dotnet.framework.aspnet.datagridc ontrol

Simon

Monday, March 12, 2012

Lookup Error handling in SSIS

Hi,

I am new to using SSIS. I need to know how can I retrieve the records in a Lookup component that cause an error to use them in a Data Transfer task. I created the error event handler but I don't know how to retrieve the records causing the error to use them in the Data Transfer task.

Thanks in advance for help!

Thanks,

Aref

I tried this and it worked,

I will redirect the record in the error configuration to be the data source to the data destination.

Thanks,

Are

|||Just to be clear for anyone not sure of this, the error flow is not always nasty errors, it can be good stuff to. Think of error as the non-default condition perhaps. For a lookup, error rows are those that the lookup failed to match, so often when loading a table that has rows in already, you would the Redirect option to send "new" rows down the error output, and then insert them.