SQLTeam.com | Weblogs | Forums

Connect to Oracle db in SSIS 2014


Hi Everyone,

I tried to create a Connection Manager in SSIS 2014 to connect to Oracle 11g database but I can't find any right default Provider. I did this in BIDS for SSIS 2008R2 and even SSIS 2012 with Attunity connectors but these only work for 2008 and 2012. Is there anyone here who has successfully configured this in SSIS 2014 engine? Please share your info or some links will help too.
Thanks in advance.


Ok, did some digging online and found Attunity Connector 3.0 was released already. So that's the solution for SSIS 2014 for connection to Oracle. Here is the link: https://www.microsoft.com/en-us/download/details.aspx?id=44582
Problem resolved!