I am novice in SSIS. I have developed one ssis package.
Here Source is Oracle and Destination is Sql server. I am using "Oracle Provider for OLEDB" for oracle connection And Sql server native client for sql server [url removed, login to view] is working fine but i am not able to create ssis package and sql jobs. So i have to run it manually.
I am shifting to new server. I am having following problems and need consultancy for it.
1. How to prepare Sql Jobs for SSIS Package?
2. I am not able to run SSIS Package into new server, Might be some oracle driver is missing. I am not able to debug the issue.
Please find attachment for error and oracle connection details.
It would take maximum 2-3 hrs for an expert in SSIS. Because i just want help in SSIS Job Creation and Making Oracle connection
18 freelancers are bidding on average ₹7120 for this job
I have deep experience in MS SQL Server development, debugging of queries with huge complexity. Also I have deep proven experience in SSIS ( I have made a lot of SSIS packages for US company during 3 years) .
I have 4.6 years of experience on ssis delvelopment and we have faced the same problem while we are migrating from one server to different server. i can help you better. please contact me. thanks in advance.
Having very good experience with SSIS, Oracle DB and development of custom components in SSIS. With overall different skillset in performing dataloads I can help you in your task
I am 7.5 years experienced in MSBI, Microsft certified, worked abroad and in MNC within [login to view URL] a massive experinecein MSBI, specially SSIS,SSAS, SSRS, SQL,ASP.NET,C#,Microsoft SQL Server