Re: Data conversion failed while converting column "officename" (70) to column "officename" (250).

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello IanO,


So you should be setting the OnError for the columns in the Source Adapter to Redirect the rows down the Error Flow. As Todd has said you can almost debug this before you try to load by using a Row Count transform

BTW use Our's it's cooler.

http://www.sqlis.com/default.aspx?77

Send your rows to a No-Op destination like the trash destination

http://www.sqlis.com/default.aspx?56


In an expression then on the workflow after the Data Flow task decide what you want to do. You could take a view that if the ratio of Good:Bad is less than a given %ge then do not carry on.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Please tell me how I can GLOBALY change the default error handling to
just keep going.
It is far more important that I get the good rows then stop on one bad
one.
This error is reported from the Data Flow Control Flat File Source.

For some time, I have been changing fail on error to ignore anywhere I
can find it.
Sometimes, it seems that SSIS is changing it back.
I'm hoping that you know of some config option that will let me make
this change.

In the meantime.. what could possibly be wrong with an office name to
cause this failure?

Thanks,
IanO


.

Relevant Pages

  • Re: How to conditionally send email task?
    ... In the control flow you have an expression on the constraint to the Send Mail Task that does something like ... In the Contraint Editor between the Data Flow task ...
    (microsoft.public.sqlserver.dts)
  • SSIS Data Flow Precedence
    ... In a Control Flow I can use precendence constraints to determine how and ... I've got a need to do something similar in a Data Flow. ... If not, process the original dataset, otherwise move to the next process. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS - Data flow transformation
    ... You cannot turn off the next step in the flow. ... The way I would do it is to break up my dataflow into multiple dataflows so that I can use Precedence constraints. ... "If a condition is met then do not execute the following piece in the data flow" ...
    (microsoft.public.sqlserver.dts)