tags:

views:

46

answers:

0
Q: 

Why is Truncation option greyed in SSIS error output?

In SSIS 2005, in a OLE DB Destination Editor, on the Error Output page, the Error column allows me to make a selection, but the Truncation column is greyed out. I want to be able to setup a path such that I can log truncations of strings when inserted into the destination table. Why is the Truncation option greyed out?

related questions

How to turn on FastParse in SSIS (SQL Server Integration Services)
Recommend ONE favorite SSIS component that does SFTP/FTPS
SSIS: Remove Duplicates from Flat File
SSIS read flat file, write to DB or C# app,mutli thread read/write?
SSIS gurus: Links to Great Learning Content requested
Potential Pitfalls of inserting millions of records into SQL Server 2005 from flat file
The best way for a SSIS ftp task to not fail when there are no files to copy
SSIS: How to progmatically direct work flow in dtsx package
SSIS Package Puzzle
Import *variable record length* CSV file using SSIS
Using SSIS to refresh a training database from a production database
What are the options for extracting data out of Hyperion 7.3 with SSIS
SSIS Oracle Parameter Mapping
Integration Services: Multiple-step OLE DB operation generated errors
How to insert a row into a dataset via SSIS
SSIS copy directory from FTP location to a shared network location
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
How Do I Check Job Status From SSIS Control Flow?
How do I get SQL Server Integration Services to use a different database connection for Package Configuration
Can you start a scheduled Windows task from SQL Server Integration Services ?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
SSIS convert image blob
Good Starting Places for SQL Server Alerts/Notifications?
Accessing Excel data source running SSIS package on 64 bit server
Execute stored procedure (SQL 2005) and place results into a CSV file on a FTP location