DSXchange

Has anyone had problems with incorrect data definitions causing Copy stages to abort?

At the moment I have a job that reads from a column from a dataset and sends it to a copy stage . The column is written to the dataset as a varchar(20) but the problem job reads it as a char(4) (and warns about it too!) but then the job aborts with this error... (occasionally!)

does that sound like something you have seen?
I am going to fix up my job and see if it becomes more reliable
and post my results here!!

<additional>
the first failure since i have been taking notice was a Copy stage "terminated unexpectedly"
the next failure in this job, was a Lookup stage
which "terminated unexpectedly"
both of these failures did NOT re-occur after a simple "restart" of the sequence which executes the job

I have removed the data mismatch and will post if the (intermittent) failures stop happening .. More tomorrow

p.s. the error message ID is IIS-DSEE-TFPM-00281

Don't do that. Start a new thread instead, so we become aware what are YOUR operating system, version number, etc.

Or I could just split it.... <snip>... done.

grogash - please edit your post and set your particulars - O/S, version, etc - unless by some chance I guessed right.

Here is the original thread, by the way:

viewtopic.php?t=136594