SQL Server DATETIME to TIMESTAMP

To load SQL Server DATETIME columns into DataStage.

To convert a microsoft SQL server datetime to a DataStage type Timestamp

The ODBC Connector column type must be Timestamp and have a scale of 3.

-- The smalldatetime data type will zero out the seconds.

Convert the column from DATETIME to DATETIME and use TIMESTAMP SQL Type in the DataStage ODBC Enterprise stage.