Home Forums SQL Server 2005 SQL Server 2005 Integration Services [Resolved] Isses with upgrading SSIS components (from 2008 to 2014) that programatically generate packages RE: [Resolved] Isses with upgrading SSIS components (from 2008 to 2014) that programatically generate packages

  • May 27, 2016 at 1:10 pm

    #1881879

    I am glad that you could resolve the issue. One other note of caution: When SSIS packages are generated dynamically using SSIS 2014, the connection manager's property ColumnNamesInFirstDataRow is set to True by default. Because of this, the package was skipping one row of data. If your file doesn't have any header rows set the ColumnNamesInFirstDataRow property to False.