Will adding new Column to the Source data break the SSIS package if its not mapped in destination


  • Hi,


    I have 3 columns from the Source file (Flat file ) mapped to 3 columns in a Sql server database( Destination).

    Will the Package break if additional columns are added to the source file without mapping to destination?

    In other words if the source file contains a 4th column that is not mapped in the destination table will the package break even if the 3 columns are mapped in the source and  destination.

    • Edited by Lousiraj Wednesday, September 25, 2013 8:40 PM
    Wednesday, September 25, 2013 8:22 PM


All replies