oracle to sql server data type mapping for ssis package using oracle attunity

We are creating an SSIS 2012 package to take data from Oracle in to SQL server using Oracle Attunity driver.

We used intermediate table approach.
We created an intermediate table on SQL server side and brought all the data from Oracle to SQL server and then moved the data into final SQL server.
The timestamp field on Oracle was mapped to varchar (75) on SQL server intermediate table side.

The date field on Oracle was mapped to datetime and not datatime2 on SQL server intermediate table side. By default the software tries to use datetime2, which we were unable to make it working.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s