No announcements
Found 3457190 threads
-
0 Votesmigrate data from sql to oracle using ssis
Which version of Oracle (more specifically than what you listed above) are you using?Answered | 16 Replies | 9513 Views | Created by Mayur-DEW - Tuesday, November 20, 2012 10:50 AM | Last reply by Mayur-DEW - Friday, November 30, 2012 2:11 PM
-
0 Votes
package using sql server configuration
yes,you need to include username and password in the connection string also, remember to use oracle provide for oracle driver. its 64bit vs ...Answered | 2 Replies | 2710 Views | Created by reddy335 - Wednesday, October 26, 2011 12:30 PM | Last reply by no_prakash - Thursday, October 27, 2011 8:09 AM -
0 Votes
SQL agent job fails to run the package - Oracle connection manager
The other way (And my preferred way ) to connect to Oracle without depending upon TNSNames.ora file is by using EZConnect connect identifier format like this: ...Answered | 3 Replies | 3328 Views | Created by Robyskariah - Friday, April 8, 2016 9:30 PM | Last reply by Manu Kapoor - Saturday, April 9, 2016 2:02 PM -
4 Votes
Using Oracle procedures in SSIS
You need this syntax when using the MS Oracle OLEDB driver (i.e. use curly brackets and a CALL statement) {call ...Answered | 14 Replies | 24898 Views | Created by Christo Olivier - Wednesday, April 25, 2007 12:11 PM | Last reply by man_25 - Wednesday, June 22, 2011 11:28 AM -
0 Votes
Connect Oracle using SSIS
Are you trying to use OLEDB provider or ODBC provider ...Answered | 5 Replies | 3239 Views | Created by Singh Randhir - Thursday, May 16, 2013 9:43 AM | Last reply by Harry Bal - Friday, May 17, 2013 8:50 PM -
0 Votes
Error while executing SSIS Package after upgrading the Oracle Client
Do you have any Date conversion functions in your Oracle datetime fields?Answered | 2 Replies | 2754 Views | Created by SQL_Help - Tuesday, June 3, 2014 2:02 AM | Last reply by Dinesh Menon - Tuesday, June 3, 2014 3:19 PM -
0 Votes
Oracle Sysdate using C#
DateTime.Now has nothing to do with Oracle.Answered | 3 Replies | 5908 Views | Created by deongee - Friday, April 11, 2014 4:34 PM | Last reply by deongee - Monday, April 14, 2014 1:04 PM -
0 Votes
Inserting into Oracle: To use or not to use Adapters?
I have posted an update to my question regarding nested data types in Oracle, sadly the Oracle WCF adapter only supports 2 nested layers max.Answered | 8 Replies | 5235 Views | Created by Miggleness - Monday, February 13, 2012 3:19 AM | Last reply by Naushad.Alam - Monday, February 13, 2012 5:13 PM -
0 Votes
connect Oracle 9i server using oracle 11g client using Oracle.DataAccess.dll
It is a different client I bet .. has been awhile but you can have a ...Answered | 1 Replies | 8859 Views | Created by Nitin Varshneya - Friday, February 1, 2013 4:46 AM | Last reply by chanmm - Friday, February 1, 2013 7:32 AM -
0 Votes
Connection error when trying to connect Oracle database from SSIS package by using OLEDB Provider
Download the appropriate Instant Client packages for your platform.Answered | 3 Replies | 1291 Views | Created by Rana_Hasan - Thursday, June 18, 2015 4:01 AM | Last reply by Dinesh Priyankara - Thursday, June 18, 2015 7:08 AM -
0 Votes
Problem getting data from Oracle Package to SQL Server or CSV file
if yes, the quick but dirty work around would be yo copy paste this in an excel spreadsheet and use the "text to columns" feature under "data" menu to convert it ...Answered | 1 Replies | 4131 Views | Created by sqlprof - Thursday, April 19, 2012 4:16 PM | Last reply by Sanil Mhatre - Thursday, April 19, 2012 4:57 PM -
0 Votes
Reading data from Oracle database using SSIS
Hi, YOu have to install oracle provider,Please check the below link which will be useful.Answered | 2 Replies | 3852 Views | Created by Fazlu - Tuesday, July 10, 2012 10:27 AM | Last reply by King kalyan - Tuesday, July 10, 2012 12:37 PM -
0 Votes
64 bit oracle client
yes I am using package configuration (using XML file). since I am using a variable (as paramter for source sql) in my package, I have included only ...Answered | 8 Replies | 4884 Views | Created by Sengwa - Thursday, August 27, 2009 5:35 PM | Last reply by Sengwa - Friday, August 28, 2009 6:33 PM -
0 Votes
how to Call Oracle CTE tables in SSIS Packages.
use the CTE in source and design the target table with the same datatype as the CTE.Answered | 2 Replies | 2272 Views | Created by Chakradhar Masineni - Monday, April 1, 2013 3:28 PM | Last reply by Dinesh Menon - Tuesday, April 2, 2013 8:57 PM -
0 Votes
Reading TABLE TYPE return values from Oracle PL SQL Package
Have you tried use ODBC Source to build the query with variable/parameter?Answered | 6 Replies | 1686 Views | Created by Madhuranga Mudannayake - Friday, September 22, 2017 5:47 AM | Last reply by Madhuranga Mudannayake - Thursday, September 28, 2017 7:44 AM -
0 Votes
Oracle to SQL
Easiest way is to use the Import Wizard in SSMS & connect to an OLE DB for Oracle Data source.Answered | 1 Replies | 6072 Views | Created by SSM - Thursday, December 15, 2011 11:11 PM | Last reply by Arya H - Friday, December 16, 2011 12:01 AM -
4 Votes
using SQL2012 - want to use existing ORACLE linked server to call an ORACLE function from SQL
What OleDB driver are you using?Answered | 9 Replies | 2670 Views | Created by GADOI - Thursday, October 3, 2013 12:12 PM | Last reply by davidbaxterbrowne - Friday, October 4, 2013 1:32 PM -
0 Votes
connect to Oracle
If you connect to Oracle from SSIS on a 64 bits machine, make sure you read this blogpost of me: ...Answered | 2 Replies | 4609 Views | Created by ArtemB - Wednesday, October 28, 2009 11:52 PM | Last reply by Jorg Klein - Thursday, October 29, 2009 8:39 AM -
0 Votes
SSIS package takes longer time when pulling data from Oracle
I do know that ssis has to run on 32 bit mode when using Oracle as source but will that cause such a huge perfomance gaps ??Answered | 5 Replies | 1506 Views | Created by vishal.... _ - Thursday, April 3, 2014 7:45 PM | Last reply by PatelChintan - Thursday, April 3, 2014 8:53 PM -
0 Votes
Problem polling Oracle by using BizTalk Adapter for Oracle
Software used.Answered | 22 Replies | 17005 Views | Created by EllaG - Thursday, April 29, 2010 6:52 AM | Last reply by erp-techi - Saturday, March 3, 2012 11:26 AM
No announcements
