DSXchange

An issue has been encountered while transferring data from SQLServer to Oracle using DS. The data in DateTime (SQLServer) field is not properly transferred into Date (Oracle) field (minutes are getting corrupted). Date field in Oracle accepts date and time.
To debug, a sequential file and a peek stage were introduced as targets and their values match those of the source column.

Source File Target
2011-12-23 09:14:34 2011-12-23 09:14:34 2011-12-23 09:12:34
2011-12-12 14:52:37 2011-12-12 14:52:37 2011-12-12 14:12:37
2012-02-22 17:13:50 2012-02-22 17:13:50 2012-02-22 17:02:50
2012-01-12 03:32:10 2012-01-12 03:32:10 2012-01-12 03:01:10
2011-11-21 15:40:54 2011-11-21 15:40:54 2011-11-21 15:11:54
2012-07-07 09:36:17 2012-07-07 09:36:17 2012-07-07 09:07:17
2011-11-19 19:08:08 2011-11-19 19:08:08 2011-11-19 19:11:08
2012-07-11 21:47:20 2012-07-11 21:47:20 2012-07-11 21:07:20
2011-09-24 15:13:14 2011-09-24 15:13:14 2011-09-24 15:09:14
2011-12-14 08:26:27 2011-12-14 08:26:27 2011-12-14 08:12:27

Could you please let me know if there are any specific settings to be tweaked to handle this scenario.

Thanks

Welcome aboard. You have posted in the incorrect forum. The moderator will be along shortly to place your query correctly, then you have to give us more information about the version and platform that you are using.

You are using MM for minutes instead of MI

Moved. I made some assumptions about your Version & O/S, please let us know if they are incorrect.

Seems like every post in the FAQ Discussion forum really belongs elsewhere. [sigh] Sad little forum.

Kryt0n wrote:You are using MM for minutes instead of MI

Nice observation!!!