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

avatar 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

avatar image

57 1 3 4

(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.

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: 2754 times

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

Copyright 2018 Redgate Software. Privacy Policy