Hi all, I've created a simple data flow using "QueryDatabaseTable" and "PutDatabaserRecord" which transfers the data from PostgreSQL DB to MSSQLServer DB in which the datatype of datetime columns in source_db i.e., PostgreSQL table is "timestamp without time zone", which is not compatible with destination_db i.e., MSSQLServer.
This logs an error, what would be the correct method to transform the datatype of the datetime columns while serving data from PostgreSQL to MSSQLServer. Can anyone give me a tip how to transform the datatype of the such columns? Thankyou in advance Deepanshu
