Search

SSIS flatfile source false behavior on redirect row on error by Christian Terhart

Active

5
0
Sign in
to vote
Type: Bug
ID: 778823
Opened: 2/8/2013 4:24:34 AM
Access Restriction: Public
0
Workaround(s)
1
User(s) can reproduce this bug
Hi there,

I have defined a flatfile connection in SSIS. (e.g. 4 columns, row delimiter <tab>, quote-ident ", row delimiter <lf>)
In the flatfile source I created an error redirect output for error and truncation.

If the flatfile has a row that does not fit the definied columns the package is failing.
If you run this in debug mode, the flatfile-source will start but not go any further when coming to error row.
The redirect of the row is not working but the tasks does not go further.
If you change the error behavior to "ignore failure" the "broken" row is ignored and the flow is working correctly.

Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Core Edition

Category

Developer Tools (SSDT, BIDS, etc.)

Operating System

Windows Server 2008 R2 Enterprise (SP1)

Operating System Language

US English

Steps to Reproduce

Create a flatfile connection (e.g. 4 columns, row delimiter <tab>, quote-ident ", row delimiter <lf>)
Create a dataflow.
Create a flatfile source.
Define error output. Set to redirect row for all columns, on error and truncation.

Create a flatfile that has one row that does not fit the defined connection above. (e.g. just 1 column, ending with <lf>)

Start it in debug mode or run it with dbutil


Afterwards change error output to ignore.
Start it again.


Actual Results

In Debug Mode: The dataflow gets stuck when reaching the "broken row".
With dbutil or as agent job:
Code: 0xC0209018    
Source: Flatflatetask in Dataflow [xx]    
Description: Failed to get data for the error output buffer. End Error
Error: 2013-02-08 07:14:28.44    
Code: 0xC0209018    
Source: Flatflatetask in Dataflow [xx]    
Description: Failed to get data for the error output buffer. End Error
Error: 2013-02-08 07:14:28.58    
Code: 0xC0202092    
Source: Flatflatetask in Dataflow [xx]    
Description: An error occurred while processing file "flatfilename.ext" on data row yy.

Expected Results

Redirect of the row in red-flowpart

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.