Home Forums SQL Server 2005 SQL Server 2005 Integration Services Importing Poorly Formatted Text File RE: Importing Poorly Formatted Text File

  • July 16, 2014 at 11:57 pm

    #1730112

    Jeff Moden (7/16/2014)

    @marg 14154,

    Are the 7 digit values for DN record type unique for each file? I ask because I have an idea for this but need to know that to firm up the approach.

    Also, is there a maximum number of different values (ie: columns) that can show up for the OPT record type?

    Yes Jeff the 7 digit values for DN are unique. For OPT, I am afraid the maximum values is not known.