Scenario; I want to transfer the data from a SQL Server Source table to an Oracle Destination table that has Date columns. I want to ensure, I copy all data (including milliseconds).
Description:
Typically, the datatype used in SQL Server tables for Date columns is DateTime which has a format of 23:59:59.997. sed However in Oracle the corresponding DataType that DateTime maps to using SSIS is 1998/05/31:12:00:00AM which truncates the milliseconds.
Depending on your project objectives or requirements it might be necessary to capture these milliseconds.
Solution:
In Oracle Table make the Date column to use Timestamp Datatype
In SSIS use Data Converstion to convert the SQL Datetime column to String. Then String maps to the Timestamp Datatype in Attunity Oracle Destination.
Detailed Solution
Too come
Comments
Subscribe to:
Post Comments (Atom)
-
Hi I was recently working on extracting a table that has 400 columns from a SQL Server DB to load into an Oracle Target Database. I design...
-
In this blog post I will show you how to implement your own custom logging in Azure Data Factory Before you do this please note that Azur... -
Scenario: I want to load data from a SQL Server table that has 1.7billion rows containing a column with data type varchar(max) which is popu...
No comments:
Post a Comment