Wednesday, October 10, 2012

[SSIS.Pipeline] Error :

[SSIS.Pipeline] Warning: The output column "Columnname" (127) on output "Flat File Source Output" (2)
 and component "Flat File Source" (1) is not subsequently used in the Data Flow task. Removing this
 unused output column can increase Data Flow task performance.
Resolution:
Check the all columns in source table match with columns in destination table, if not uncheck extra column
 From the 'Available External Columns' in the Flat file Source Editor by right clicking the Flat file Source.

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...