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 using SSIS

    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

Viewing 0 posts

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