DSXchange

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 'create' and deleting the existing table. I have also removed the stage and rebuilt it, with the same results. We had the same issue using SQLServer stage, and changing to ODBC stage seemed to solve it. However, ODBC stage is now doing this. Any help would be appreciated.

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.