Test file import into sql table using SSIS

• mtz676

  SSCrazy Eights

  Points: 9214

  More actions

  November 21, 2015 at 11:36 am

  #305482

  How do I import only the first column(in bold) without the column name into a sql table from the following text file.

  Sample data:

  ServerName InstanceName IsClustered Version - Line 1

  ---------- ------------ ----------- ------- - Line 2

  ABCDEFGHI No 10.0.4000.0 - Line 3

  ABCDEFGHI MSSQLSERVER2012 No 11.0.3000.0

  SFVSDVSDV No 11.0.5058.0

  HDDBHDGHH No 10.50.1600.1

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  November 24, 2015 at 3:56 am

  #1841977

  Hi

  Please set up properties "ColumnNamesInFirstDataRow - False and

  DataRowsToSkip - 2 in the Flat File Connection.

  You have to uncheck all columns except first one in Flat File Source.

  Best regards,

  Mike