Home Forums SQL Server 2005 T-SQL (SS2K5) Controlling column order when reading text file based on schema.ini and OPENDATASOURCE RE: Controlling column order when reading text file based on schema.ini and OPENDATASOURCE

  • Hi Samuel,

    Thanks very much for the explanation. For files with a relatively small number of columns, explicitly naming them in the select is not a problem. Really I was mostly curious about the behavior - didn't find it in the documentation.

    Thanks again,

    -Steve Lord