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.