No announcements
Found 1737547 threads
-
0 VotesEmulting Oracle packages in SQL Server
There is no such thing as packages in SQL Server (unfortunately).Answered | 1 Replies | 6221 Views | Created by SQLAJ - Monday, January 25, 2010 4:31 PM | Last reply by TiborK - Tuesday, January 26, 2010 1:04 PM
-
0 Votes
Oracle and SQL Server source in the same package
Our Line of business application supports Sql Server and Oracle as OLTP database.Answered | 5 Replies | 4177 Views | Created by asiva - Tuesday, February 16, 2010 7:23 PM | Last reply by Charles Wang - MSFT - Friday, February 19, 2010 3:28 AM -
0 Votes
SSIS Package Execution from .Net code - Connecting Oracle and Sql server
App server(64 bit) - .Net code running the dtexec utility to load and execute an SSIS package.Answered | 3 Replies | 3053 Views | Created by Avinash Bavanala - Thursday, February 2, 2012 6:23 AM | Last reply by Eileen Zhao - Wednesday, February 8, 2012 3:14 AM -
0 Votes
Oracle to SQL Server
Hi, Yes by using SSIS Data can be moved to SQL Server, Oracle Client to be installed on the SQL Server to create a connection string in ...Answered | 4 Replies | 1029 Views | Created by collie12 - Tuesday, February 2, 2016 8:33 PM | Last reply by SKB7 - Wednesday, February 3, 2016 9:29 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 into a ...Answered | 1 Replies | 4158 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
Connectivity to Oracle from Package
I am testing on the same server on which the SP is running, the SP and the package are on the same machine/server/Answered | 4 Replies | 912 Views | Created by Sudhakar Vallamsetty - Wednesday, October 1, 2014 10:26 AM | Last reply by Visakh16 - Wednesday, October 1, 2014 11:18 AM -
0 Votes
Moving data from sql server to oracle through ssis package.
oh yaa i have got the data of sql server table into my oracle table.Answered | 5 Replies | 8168 Views | Created by Jiten.negi - Monday, October 3, 2011 10:54 AM | Last reply by Jiten.negi - Tuesday, October 4, 2011 4:12 PM -
0 Votes
Packages in SQL Server
There are no packages; i.e., collections of procedures and functionsBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ ...Answered | 2 Replies | 5045 Views | Created by Dileep Krishnan - Monday, March 14, 2011 1:20 PM | Last reply by Uri Dimant - Monday, March 14, 2011 1:37 PM -
1 Votes
migration from oracle to sql server
SQL Server Migration Assistant for Oracle in your case.Answered | 6 Replies | 1645 Views | Created by delaynomore - Tuesday, July 25, 2017 6:55 AM | Last reply by Mohammad Ali Torabi - Wednesday, August 23, 2017 11:31 AM -
1 Votes
Fetch data from oracle server to sql server
SSIS Import/Export Wizard is the best choice: http://www.sqlusa.com/bestpractices/ssis-wizard/ Alternative is linked ...Answered | 3 Replies | 2164 Views | Created by Sandy.S - Wednesday, April 30, 2014 5:32 AM | Last reply by Kalman Toth - Sunday, May 4, 2014 10:37 AM -
0 Votes
package using sql server configuration
Check out: http://connectionstrings.com/oracle Tom SQL Server MVP Toronto, ON CanadaAnswered | 2 Replies | 2753 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
Oracle to MS SQL server load is slow
Can PRIMARY memory allocation at the MS SQL server be a reason for the package to run slow?Answered | 7 Replies | 3799 Views | Created by Jim123456789jim - Thursday, October 10, 2013 3:40 PM | Last reply by mhm_2004de - Friday, October 11, 2013 2:36 PM -
0 Votes
Oracle to SQL Server
And this is the best article for trying to improve and monitor the performance of this SSIS ...Answered | 1 Replies | 2748 Views | Created by pokdbz2909 - Thursday, February 16, 2012 4:05 PM | Last reply by ArthurZ - Thursday, February 16, 2012 4:24 PM -
0 Votes
SQL server equivalent for Oracle Spool
IMHO, your best and easiet way to do is using SSIS or data export wizard and save the file(package) and schedule to run to using ssis.Answered | 6 Replies | 15361 Views | Created by Gasciero - Monday, February 18, 2013 3:31 PM | Last reply by JRStern - Monday, February 18, 2013 5:56 PM -
0 Votes
Importing data from SQL Server to Oracle.
I want to know how to establish Oracle as a Subscriber with SQL server as publisher ??Answered | 7 Replies | 5458 Views | Created by Tapas Dash - Monday, September 14, 2009 8:54 AM | Last reply by Tapas Dash - Wednesday, September 16, 2009 4:38 AM -
0 Votes
Oracle to SQL
I am assuming you are importing to SQL 2008?Answered | 1 Replies | 6132 Views | Created by SSM - Thursday, December 15, 2011 11:11 PM | Last reply by Arya H - Friday, December 16, 2011 12:01 AM -
0 Votes
Random Connection Failure to Oracle from Packages
This can be caused by many variables, on the SQL Server, network, or Oracle.Answered | 4 Replies | 1413 Views | Created by Greg Coles - Monday, December 29, 2014 7:35 PM | Last reply by Ron Verhoeven - Tuesday, December 30, 2014 8:03 PM -
0 Votes
Does SQL Server Replication work with Oracle 12C?
Hello, We are on the same situation with SQL 2012 replication from Oracle 12C.Answered | 4 Replies | 3835 Views | Created by Simplex-DBA - Thursday, December 17, 2015 7:25 PM | Last reply by Grégory CASANOVA - Thursday, January 21, 2016 1:42 PM -
0 Votes
SQL Server linked to Oracle
Or is that reserved for SQL Server DBs only?Answered | 3 Replies | 5471 Views | Created by bobk544 - Friday, November 20, 2009 4:00 PM | Last reply by Brian Tkatch - Monday, November 23, 2009 2:42 PM -
0 Votes
Oracle --> SSIS --> SQL Server
NUMBER (5,0) ---> DT_14 --> NUMERIC (5,0) a valid combination from Oracle ---> SSIS ---> SQL Server?Answered | 4 Replies | 1649 Views | Created by etl2016 - Tuesday, October 4, 2016 10:50 AM | Last reply by ArthurZ - Tuesday, October 4, 2016 3:58 PM - Items 1 to 20 of 1737547 Next ›
No announcements
