0

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

comp_user
  • 60
  • 7
  • 1
    Personally, I'd take off the Microsoft goggles and use Oracle's own 'sqlldr' tool https://docs.oracle.com/en/database/oracle/oracle-database/18/sutil/oracle-sql-loader.html#GUID-8D037494-07FA-4226-B507-E1B2ED10C144 or create an external table: https://docs.oracle.com/en/database/oracle/oracle-database/18/sutil/oracle-external-tables.html – EdStevens Apr 12 '21 at 23:12
  • Does your Oracle database have Apex installed? There is a GUI tool there for uploading CSV files into a table. – eaolson Apr 12 '21 at 23:17
  • I am pretty new to this but my org requires the use to SSIS package to automate the data uploading process, I am not sure about Apex to be honest, just wondering if its possible to upload the csv file using ssis into the oracle database – comp_user Apr 12 '21 at 23:30
  • @ops_mltsd what is the type of extract_month in your source and destination? – Amira Bedhiafi Apr 13 '21 at 19:25
  • The extract month datatype in source and destination is a DT_STRING. I made sure that all the datatype is the same between source and destination – comp_user Apr 15 '21 at 21:22
  • 1
    Hover your mouse over the input column "extract_month" and compare the datatype to destination column EXTRACT_MONTH by hovering the mouse over that as well. If they match, double click on the arrow between source and destination and make sure the datatype of "extract_month" is the same – Gigga Apr 17 '21 at 08:56
  • 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 – comp_user Apr 22 '21 at 13:38

1 Answers1

0

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

comp_user
  • 60
  • 7