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 [login to view URL] 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
17 freelancers are bidding on average ₹7277 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) .
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 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.
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