DSXchange

A work-around is to select the "Create Statement" option in the Options section of the Properties tab of the ODBC table object. By explicitly defining the SQL code of the create statement, you can get the table structure you require.

I have an ODBC Enterprise stage writing to an SQLServer database table. The order of columns shown in the stage is different in the table created by the stage. Several columns change positions - but consistently with the same wrong positions! I am using 'replace' write mode, but have also tried 'cre...