Test file import into sql table using SSIS

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply