No announcements
Found 1730386 threads
-
10 VotesAdding Oracle Data Source in SSIS - The given path's format is not support
Use the "All" connection string editor (click on the Oracle Connection at the bottom on the big Data Flow screen, not the OLEDB input and look at ...Answered | 12 Replies | 28985 Views | Created by danimian - Monday, November 21, 2011 11:31 AM | Last reply by Jaypatel1988 - Thursday, March 14, 2019 7:42 PM
-
0 Votes
SSIS Source change from Ado.net to oracle Source
we are also using Attunity to use oracle source/destination.Answered | 3 Replies | 836 Views | Created by Akhil_G - Thursday, June 2, 2016 4:34 AM | Last reply by ArthurZ - Monday, June 6, 2016 11:33 PM -
1 Votes
Oracle connection fails in debugging
You need to contact Oracle support or forums as we do not have access to Oracle's source code: (Answered | 3 Replies | 2229 Views | Created by ChrisWest10 - Thursday, October 3, 2013 3:41 PM | Last reply by ChrisWest10 - Sunday, March 2, 2014 6:23 PM -
0 Votes
SSIS connectivity to oracle DB
Hi SukanyaCu, Is there any variables referenced in your connection string?Answered | 17 Replies | 2119 Views | Created by SukanyaCu - Friday, January 19, 2018 10:05 AM | Last reply by SukanyaCu - Friday, February 2, 2018 1:13 PM -
0 Votes
Oracle as source
Another cause of the issue could be another bulk data task such as index rebuilds.Answered | 4 Replies | 663 Views | Created by DileepReddyAchhala - Monday, March 2, 2015 6:03 PM | Last reply by Anthony C-UK - Tuesday, March 3, 2015 12:40 PM -
0 Votes
Connect Oracle using SSIS
Paste the tnsnames.ora file to the following path ....ORACLE_HOME/Network/adminAs Shanky, provided the link, ...Answered | 5 Replies | 3001 Views | Created by Singh Randhir - Thursday, May 16, 2013 9:43 AM | Last reply by Harry Bal - Friday, May 17, 2013 8:50 PM -
1 Votes
oracle - how to connect
You can make use of the Oracle Client.Answered | 3 Replies | 3164 Views | Created by middlecowboy - Saturday, May 23, 2009 3:16 PM | Last reply by Ganesh Ranganathan - Bangalore, India - Saturday, May 23, 2009 8:32 PM -
0 Votes
Connectivity with oracle database
The next step would be to check with Oracle and see if they have an odbc provider for that version.Answered | 3 Replies | 7523 Views | Created by ap12 - Monday, July 25, 2011 5:12 AM | Last reply by Al Edlund - Saturday, July 30, 2011 12:48 PM -
0 Votes
Oracle connection failure
am using a Dataflowtask...in that i used a ole db source and selected my source table and used a row count task.Answered | 12 Replies | 1313 Views | Created by SSDL - Tuesday, March 25, 2014 6:19 AM | Last reply by AB82 - Thursday, March 27, 2014 7:06 PM -
1 Votes
SSIS - Connecting to Oracle
Do you have idead what could still causing this issue about data precision from Oracle?Answered | 9 Replies | 49626 Views | Created by Peter Gadsby - Thursday, January 19, 2006 2:56 PM | Last reply by JayZhizi - Monday, July 7, 2014 7:21 PM -
1 Votes
Cannot create a connection to data source 'oracleDB'.
Download them from the oracle's web site.Answered | 4 Replies | 10208 Views | Created by Div - Thursday, May 10, 2007 5:43 AM | Last reply by Nissim Natanov _MSFT_ - Tuesday, April 14, 2009 9:38 PM -
2 Votes
Deploy with external source (Oracle)
If you are using Oracle as a external datasource, the link below could be helpful: ...Answered | 5 Replies | 938 Views | Created by Phero_ - Thursday, October 2, 2014 10:46 AM | Last reply by Angie Xu - Wednesday, October 15, 2014 5:49 AM -
1 Votes
Attunity Oracle Source - select with a parameter
But then what to set in the "Oracle Source" inside the DataFlow ?Answered | 6 Replies | 10860 Views | Created by AntonioCH - Thursday, September 3, 2009 9:52 AM | Last reply by joffrey22 - Friday, May 11, 2018 1:01 AM -
0 Votes
Multidimensional Data Source definition
Hi Torben E, According to your description, if you have colon in your connection string when creating data source, it will throw error.Answered | 1 Replies | 637 Views | Created by Torben E - Thursday, January 15, 2015 10:50 PM | Last reply by Simon_Hou - Monday, January 19, 2015 1:58 PM -
2 Votes
connect to Oracle for dashboards
Hi, Unfortunately SharePoint Designer doesn't support connecting to Oracle database.Answered | 3 Replies | 2938 Views | Created by SharePointGuy123 - Friday, June 29, 2012 3:56 PM | Last reply by Thuan Soldier - Tuesday, July 3, 2012 11:39 AM -
0 Votes
Oracle connectivity
Then you have to install 32 bit Oracle Client.Answered | 3 Replies | 1627 Views | Created by Rakesh Ponnala - Friday, February 5, 2016 9:34 AM | Last reply by Olaf Helper - Friday, February 5, 2016 10:53 AM -
0 Votes
ORA-00936 error - SSRS 2008 R2 parameterized report, Oracle Provider for OLEDB connection to the data source
Kumar, What do you mean by a regular Oracle connection within BIDS?Answered | 6 Replies | 13758 Views | Created by Yulia F - Tuesday, July 12, 2011 8:19 PM | Last reply by Nehemiah Willis - Wednesday, July 13, 2011 4:11 PM -
0 Votes
Oracle Connect
Microsoft provides "Microsoft OLE DB Provider for Oracle", but I think it is very old and not recently maintained.Answered | 3 Replies | 2424 Views | Created by sqlrich - Tuesday, November 29, 2011 5:04 PM | Last reply by COZYROC - Wednesday, November 30, 2011 8:42 PM -
0 Votes
oracle adapter not connecting
i have now installed oracle data access 11.1.0.6.21...Answered | 7 Replies | 12137 Views | Created by JAT14 - Tuesday, March 3, 2009 6:42 PM | Last reply by Manas G - Friday, March 6, 2009 10:16 AM -
0 Votes
datetime parameter against Oracle data source
Which data type have you used for the parameters?Answered | 3 Replies | 1296 Views | Created by thotwielder - Friday, February 28, 2014 12:01 PM | Last reply by Olaf Helper - Saturday, March 1, 2014 8:41 AM
No announcements
