Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Oracle "table or view does not exist" after successful SSIS table export

  I successfully exported a table using Visual Studio 2008 SSIS to an Oracle database. I see the tab…

  JP10

  2 replies

  10 years, 9 months ago

  By: JP10

• Execution plan difference when executed from Oracle VS SSMS

  Hi. We are having performance problems on our server. We have found out that execution plans (attac…

  Ville-Pekka Vahteala

  4 replies

  10 years, 9 months ago

  By: Ville-Pekka Vahteala

• Primavera

  I am using Primavera 6.0 my laptop crash and i replace, the PMDB I can no longer log in SQL reports…

  gcruz 43255

  2 replies

  10 years, 11 months ago

  By: Ford Fairlane

• Pass a parameter to OpenQuery?

  Why does not the four-part naming convention work?!? I need to pass a parameter and am struggling t…

  Michael Gerholdt

  9 replies

  10 years, 11 months ago

  By: Jeff Moden

• OBIEE vs SSRS

  Hello, I got a reporting requirement in my project and OBIEEE was decided to be used as a standard …

  Deeps-965988

  10 replies

  10 years, 12 months ago

  By: Mani-584606

• how to add article using sp_addarticle

  I want to add article using the procedure sp_addarticle but the problem is that my publisher is ora…

  snehasis.pattnaik 57469

  1 replies

  11 years ago

  By: snehasis.pattnaik 57469

• Totally lost on creating a linked server from 2008R2 to Oracle

  I've reviewed the two threads here, and many articles from doing a Goggle search. They all follow …

  david.robson

  15 replies

  11 years ago

  By: david.robson

• Adding an Oracle Data Source in SSIS

  Windows Server 2003 DC 32-bit/MSSQL 2008 /Oracle Client 10.2 I've tried adding various Oracle data…

  Opus

  2 replies

  11 years ago

  By: Omo Eko

• Passing an argument to an Oracle Stored Procedure and returning a record set to SSRS 2008 R2

  Hi all! I am having an issue retreiving data from a Stored Procedure in Oracle to SSRS. First, I h…

  the.eviled209.40k

  7 replies

  11 years, 1 month ago

  By: pedroamg

• Can't connect to a remote Oracle server

  Win 2008 server 64 bit Bids 2008 SQL Server 2008 R2 Driver: Oracle 11.02.00.01 So I've done the fol…

  Resender

  3 replies

  11 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Making SSIS work for extraction from Oracle11g to Sql Server 2008 on a 64bit server.

  Hi, I am trying to execute a sql agent job (ETL from Oracle 11g to Sql Server 2008) on a 64bit serv…

  ashiyana14

  3 replies

  11 years, 2 months ago

  By: Dscheypie

• Replicating only Newly added Article in SQL Server 2008 R2

  I am using an publisher as Oracle database and my Distributer and subscriber are both SQL server.i …

  snehasis.pattnaik 57469

  1 replies

  11 years, 3 months ago

  By: snehasis.pattnaik 57469

• Converting an Oracle trigger to SQL Server 2008

  Hello - I'm new to SQL Server and this forum. I'm trying to convert a simple Oracle trigger to SQL …

  rodgersem

  2 replies

  11 years, 3 months ago

  By: Jeff Moden

• Moving Oracle 10g and 11g into SQL 2008 R2 using SSIS

  Hi All, I need to move oracle 10g and 11g data into sql 2008 using SSIS 208 and we have BIDS 2008 R…

  Shaun2012

  2 replies

  11 years, 3 months ago

  By: PaulB-TheOneAndOnly

• Oracle Instant Client on SQL 2008 R2 64bit

  Hi Everyone. I hope someone can help me quickly. I am really stuck. I've installed the 64bit vers…

  Patti Johnson

  5 replies

  11 years, 4 months ago

  By: Patti Johnson