My SQL server is in CET All datetime columns are imported in CET. Now I have one table in which the datetime is stored in UTC. How can I import this UTC time column in DB Connect 2 so DB connect knows that this column is in UTC instead of CET.
You can just do it in your SQL query
https://msdn.microsoft.com/en-us/library/ms186819.aspx
SELECT DATEADD(hour, -1, DATEADD(second, yourTimeStampColumn, '1970-01-01'))