Publisher review:SQL Column width from delimited text script was written to find the maximum length of each column in a delimited text file. When loading text files into database tables (MSSQL in this example), the source columns often do not match the table definition. This script was written to find the maximum length of each column in a delimited text file, then modify the a table create DDL file to make each character column wide enough, so truncation errors do not occur.
SQL Column width from delimited text 1.0 is a Python script for Database Tools scripts design by Matt Keranen.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
SQL Column width from delimited text script was written to find the maximum length of each column in a delimited text file.
Operating system:Windows / Linux / Mac OS / BSD / Solaris