No announcements
Found 1856372 threads
-
0 VotesSSIS - Oracle Provider error
John hi, you either need to install the 64 bit Oracle driver, or instruct the package running in 32 bit mode (provided you have successfully configured the ...Answered | 6 Replies | 5370 Views | Created by John Fend - Monday, October 1, 2012 11:31 PM | Last reply by John Fend - Tuesday, October 2, 2012 2:32 PM
-
0 Votes
ORACLE SSIS connection - ERROR
Microsoft Connector Version 2.0 for Oracle by Attunity to load data into Oracle or unload data from Oracle in the context of Microsoft SSIS?Answered | 2 Replies | 1644 Views | Created by dj2907 - Wednesday, January 28, 2015 8:28 PM | Last reply by Katherine Xiong - Thursday, January 29, 2015 9:08 AM -
2 Votes
Oracle 64 bit providers and SSIS/BIDS
I also found that if you use the ADO.NET SoURCE instead of the OLE DB Source with the Oracle client provider for .NET mimimizes the impact of the data type ...Answered | 12 Replies | 5919 Views | Created by Timothy1170 - Monday, February 16, 2009 3:21 PM | Last reply by Dinesh Menon - Wednesday, October 3, 2012 1:46 PM -
0 Votes
SSIS Connectors for Oracle by Attunity vs Oracle provider for OLE DB performances - SSIS 2012
Hi, Microsoft Attunity connector for Oracle would work in both scenarios, where SSIS is used to fetch the data from Oracle source and Load in SQL Server.Answered | 4 Replies | 5308 Views | Created by pscorca - Friday, April 4, 2014 12:50 PM | Last reply by Don Castelino[MSFT] - Wednesday, February 14, 2018 7:26 AM -
0 Votes
Oracle to SQL migration error with SSIS
This is Oracle Problem Please look at followingAnswered | 1 Replies | 5963 Views | Created by SQL_BOSS - Tuesday, November 23, 2010 6:44 PM | Last reply by Gaurav Gupta - Tuesday, November 23, 2010 6:56 PM -
0 Votes
Oracle provider for OEL DB is not showing in Connection manager in SSIS
SSIS will run properly.Answered | 4 Replies | 2082 Views | Created by Santosh Yadu - Tuesday, November 17, 2015 12:43 PM | Last reply by Visakh16 - Tuesday, November 17, 2015 1:21 PM -
1 Votes
MS OleDB Provider for Oracle - Error 0xC0202009
Thus, the MS OLEDB for Oracle Provider and .Net Provider\Oracle client just started working.Answered | 15 Replies | 8704 Views | Created by mg101 - Monday, September 23, 2013 3:15 PM | Last reply by mhm_2004de - Wednesday, October 2, 2013 4:54 PM -
0 Votes
Connect to Oracle through SSIS
Bikash, Check this blog post of me: ...Answered | 2 Replies | 3712 Views | Created by Bikash Dash - Monday, December 14, 2009 5:33 AM | Last reply by Jorg Klein - Monday, December 14, 2009 7:53 AM -
0 Votes
Connect Oracle using SSIS
Server name=hostname:PortNumber/ServiceName Drag a Ado.net source and choose .net provider\ ODBC data provider.Answered | 5 Replies | 3343 Views | Created by Singh Randhir - Thursday, May 16, 2013 9:43 AM | Last reply by Harry Bal - Friday, May 17, 2013 8:50 PM -
3 Votes
Install oracle client for SSIS
I also had issues while installing Oracle for SSIS on my machine.Answered | 5 Replies | 27490 Views | Created by msloy - Tuesday, June 12, 2012 9:03 PM | Last reply by Koen Verbeeck - Wednesday, June 13, 2012 8:31 AM -
0 Votes
SSIS with Oracle
Check out these ...Answered | 1 Replies | 2144 Views | Created by msloy - Thursday, May 30, 2013 11:58 PM | Last reply by Eswararao C - Friday, May 31, 2013 6:08 AM -
0 Votes
Usign Microsoft OLE DB Provider for Oracle - SSIS 2012
Hi, in order to use SSIS to read Oracle data I've installed the Oracle Data Access Components (ODAC) for Windows that allow to use some providers ...Answered | 11 Replies | 21845 Views | Created by pscorca - Thursday, September 5, 2013 7:43 AM | Last reply by pscorca - Monday, September 16, 2013 3:44 PM -
0 Votes
Oracle Provider for OLEDB
Hi, Download and install Oracle10g Provider for OLE DB In Oracle docs you can get step by step guide in installing provider ...Answered | 3 Replies | 1062 Views | Created by DileepReddyAchhala - Monday, November 16, 2015 9:20 AM | Last reply by SathyanarrayananS - Monday, November 16, 2015 2:08 PM -
4 Votes
Using Oracle procedures in SSIS
I was using the Provider=OraOLEDB.Oracle.1 and SSIS SP2.Answered | 14 Replies | 25005 Views | Created by Christo Olivier - Wednesday, April 25, 2007 12:11 PM | Last reply by man_25 - Wednesday, June 22, 2011 11:28 AM -
3 Votes
execute oracle procedure from SSIS
Thank you for this suggestion it was what I needed to execute my Oracle Stored Procedure from SSISAnswered | 16 Replies | 25074 Views | Created by sqlstar - Tuesday, September 18, 2007 7:46 PM | Last reply by I_Love_Life - Saturday, November 5, 2016 12:45 PM -
0 Votes
ssis ERROR IN ORACLE TO SQL MIGRATION
I had a lot of problems with Money and Dates going from Oracle to SQLServer.Answered | 2 Replies | 5256 Views | Created by SQL_BOSS - Tuesday, November 16, 2010 8:06 PM | Last reply by MikeChicago - Tuesday, November 16, 2010 9:02 PM -
0 Votes
Supported data providers for Oracle in Azure Data Factory SSIS IR
Hi all, we are using Azure Data Factory SSIS Integration Runtime service to run our existing SSIS packages.Answered | 3 Replies | 683 Views | Created by Gayan Dasanayake - Tuesday, April 14, 2020 1:39 PM | Last reply by Lukas DreiKlein - Wednesday, April 15, 2020 6:26 AM -
0 Votes
Connecting to oracle Db using SSI
Now I am able to connect to the oracle database using SSIS connection managers.Answered | 9 Replies | 1858 Views | Created by S Prashant - Monday, May 20, 2013 10:27 AM | Last reply by S Prashant - Wednesday, May 22, 2013 9:32 AM -
0 Votes
Source as Oracle database in SSIS
Contact your ORACLE DBA.Answered | 5 Replies | 1577 Views | Created by on7june - Friday, February 28, 2014 9:34 AM | Last reply by on7june - Monday, March 10, 2014 8:32 AM -
0 Votes
SSIS connectivity to oracle DB
Oracle Provider for OLE DB 12.1.0.2 supports the IRowsetFastLoad interface, which enables fast memory-based bulk-copy operations in the Oracle ...Answered | 17 Replies | 2698 Views | Created by SukanyaCu - Friday, January 19, 2018 10:05 AM | Last reply by SukanyaCu - Friday, February 2, 2018 1:13 PM - Items 1 to 20 of 1856372 Next ›
No announcements
