SSIS 2005 - Configure Error Output for a Dataflow task

I am unable to get the Error rows to be redirected to an error table. I am using a DataFlow task with excel as input and an OLE DB Destination as an output with a transformation task in between. Tried to configure the error output on the transformation task and redirected it to an error table. The errors are not diverted and the Dataflow task fails. Can someone help me? Thanks - Jaya

more ▼

asked Feb 15, 2010 at 07:55 PM in Default

Jaya gravatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
more ▼

answered Feb 16, 2010 at 12:00 PM

mabc360 gravatar image

57 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 15, 2010 at 07:55 PM

Seen: 2565 times

Last Updated: Feb 16, 2010 at 06:17 AM