Skip to Content
0
Former Member
Apr 14, 2014 at 07:46 AM

Datetime issue when loading data

52 Views

Hi,

Am loading a table from oracle to sql server in BODS, which has a datetime column in source.

when i use SSIS ( ETL tool ) , the corresponding datetime column is getting loaded as

2012-12-16 08:00:00 , which is correct.

But when i use BODS, it is getting loaded as

2012-12-16 08:00:00.000000

In destination this column is varchar(30).

how can i restrict this in BODS ?