Question: how to import data from oracle to sql server using ssis?
Answer: Add the Components. To get started, add a new Oracle Sales Cloud source and SQL Server ADO.NET destination to a new data flow task.
Create a New Connection Manager. ... 
Configure the Oracle Sales Cloud Source. ... 
Configure the SQL Server Destination. ... 
Run the Project.