How to migrate data from Oracle to SQL Server using Devart SSIS

[@challanaveen1014]

With ssis in built oledb source can’t we connect to oracle database ?

[@learnssis]

We would need to install the ODBC drivers for Oracle, create system\user dsn and then try connecting either using ODBC source or ado.net source.

[@WalaaElnokrashy]

I need to ask if I can use devart SSIS with Visual Studio 2022? , it says that it up to version 2019 , so what Vs version u use please ?

[@learnssis]

I am using Visual Studio 2019. So far it does not supports Visual Studio 2022.

[@pradeepKumar-rr6og]

Devart is giving trail period , its not free . Can you provide alternate solution ?

[@learnssis]

You would need to download the ODBC drivers for Oracle and then make a User DSN and System DSN on your machine for both 32-bit drivers and 64-bit drivers. Now you can use those DSN in the ssis package to connect to Oracle. A very basic video after DSN is created is here
ruclips.net/video/9ERUehK1fgs/видео.html

[@Hadeer.H.abdelaziz]

Devart is not free, is there any free alternative?

[@learnssis]

You can try downloading and installing the ODBC drivers for Oracle, create the DSN for 32 bit\62 bit. Now use those DSN inside ODBC source component to pull the data from Oracle.

[@BN-ys1sj]

🙏💯

[@learnssis]

You are welcome.