Search code examples
oraclessisvisual-studio-2017attunity

How to load flat file into Oracle database

I am trying to import data from a csv file to an Oracle database, I am using Visual Studio 2017 I have downloaded all required components such as SSDT 15.8; and Attunity version 5.0

I was wondering if someone could please guide me on how I can load the flat file from csv to an Oracle table.

So far, I dragged and dropped the flat file and connected it to an Oracle Destination, however, even after mapping, as you can see, the red cross in Oracle Destination is still there

enter image description here

And when I tried to "Start" the process, this is the error message I got:

enter image description here

If somebody could please help me, that would be great. Below is a screenshot of the mapping i did:

enter image description here

thank you

Solution

  • Thank you for our help everyone, I resolved it by ensuring that the datatype in source matches the datatype in destination. Also, a major thing to consider is to ensure that the user you are logged in as has permission to write to the database, the user I was logged as did not have permission which is why I was getting that error