Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

configure OLE DB Destination Error Output Expand / Collapse
Posted Friday, January 11, 2013 12:41 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 29, 2016 7:57 AM
Points: 57, Visits: 371
I have an ssis Job (SSIS 2008) that loads data from a flat file to an SQL server 2008 table.
I have a dataflow component where I do some transformations, and load to the database using an OLE DB Desination.

on the destination, I configured the data access mode to: "table or view"
however, when I open the error output, I can not configure an error on truncation. The field is grayed out.
What am I missing, why can't I configure the error output
Post #1406234
Posted Tuesday, January 15, 2013 2:21 AM



Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 15,499, Visits: 13,162
In the OLE DB Destination, you won't get Truncation Errors (those are used in the pipeline of the dataflow). If there's a truncation error, it happens in the database engine and SSIS regards it as any other error. So you need to configure On Error.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1407105
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse