Understood. Makes sense what is happening.

In this situation, having the Flat File Connection setup with Error Output of "redirect row" for this column wouldn't work??  I have it...

It's giving a specific column that doesn't have the delimiter though..... in this instance "The column delimiter for column "ITEMMASTER_DESCRIPTION" was not found".

So are you saying since it...

Agreed... I have the flat file source set to "redirect error rows" but it's not doing it.  It's failing the package.

Thanks for all the feedback.

John

Thanks for the reply.

I think it will be viewed quite often by many users. Is Ssrs even an option for a front end? I'm thinking not as a...

Input

PO Number

Company ID

PO Line Num

PO Date

Vendor Num

Vendor Facility

Account Number

Tax Flag

Part Num

Part Desc

Received QTY

Received Price

Invoice Number

Invoice Date

Output (.csv)

Header for each record invoice above

Record Type (H)

Vendor

Invoice No

Site

Business Entity

Invoice Date

Posting Period

Gross Amount

Discount Amount

Due...