Who is online?  0 guests and 1 members
Home  »  search results

Search Results: Oracle

149 results found
  • SSIS and Oracle connections
    ***UPDATE*** The new SSIS connectors for Oracle and Teradata are available now. http://blogs.msdn.com/b/mattm/archive/2012/04/04/microsoft-connectors-v2-0-for-oracle-and-teradata-now-available.aspx FYI the 2.0 version is for 2012 only… You want the
    Author: MMilligan MMilligan     Date: 6/9/2011     Section: Blog
  • Loading data to Oracle
    I have a few about SSIS and need you to help . Currently I developed ETL package using SSIS to loading data from MSSQL Server to Oracle and between Oracle to Oracle. I found that the performance is very poor (using 1 hour to load 1 M records) and the pack
    Author: user078224 user078224     Date: 5/14/2012     Section: Forum
  • Can a SSRS report serve as a datasource for another SSRS report?
    I think Brian said it all. Let me just aware you when you say this: Christian said: Is it possible to combine reports (or at least data from the reports) from both sources (SQL and Oracle) onto a single "dashboard-type" report? Or is an rdl limited to one
    Author: marcoadf marcoadf     Date: 1/4/2012     Section: Forum
    tags : multipe, query, reports
  • 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 have to keep this Stored Procedure in Oracle because it is passing data of the LONG data type to SSRS and I can not seem to find a way to get a SQL Storded Pr
    Author: EvilEd209 EvilEd209     Date: 5/6/2011     Section: Forum
  • Querying Oracle from SSIS
    I've been working my way through various problems related to querying an Oracle DB from SSIS. In case it helps anyone, here's what I learned. Microsoft Provider or Oracle Provider? When I first started writing packages that queried Oracle, I assumed the O
    Author: JustinJohnson JustinJohnson     Date: 8/5/2011     Section: Blog
    tags : oracle, ssis
  • My Connection Manager isn't Saving my Password
    When you're working in SSIS, there are definitely some quirks that can drive you crazy. Luckily, most of them have a pretty simple resolution. One example of this is Connection Manager passwords not being saved in your package. Let's say you set up a conn
    Author: kylewalker kylewalker     Date: 2/22/2011     Section: Blog
  • Can a SSRS report serve as a datasource for another SSRS report?
    Can SSRS reports serve as datasources for other reports? I'm working to retire an old Access application that was created ages ago. Now that we have SSRS, I'm replicating as closely as possible in my new reports the look and feel users are familiar with.
    Author: Christian Christian     Date: 1/3/2012     Section: Forum
  • SSIS Package Failed via SQL Agent
    Jeff- https://forums.oracle.com/forums/thread.jspa?threadID=1008412 This thread suggests that instead of using the Microsoft OLD DB Provider for Oracle, you should use the "Oracle Provider for OLE DB". Hope it helps, Keith Hyer
    Author: KeithHyer KeithHyer     Date: 2/6/2012     Section: Forum
    tags : oledb
  • Command text was not set for the command object
    Are you using SQL Server as a data source or are you using a different SQL Engine as the source for this query? ** If ** it's SQL Server: The issue is probably that there is no "TO_CHAR()" function in T-SQL. Nor is there a "substr" function. In their plac
    Author: KeithHyer KeithHyer     Date: 2/7/2012     Section: Forum
  • oracle data source input in SSIS
    Thanks for your reply. I tried to debug and find what actually is causing this problem. I think "Number" datatype represents and float number. So, the corresponding column in the destination sql table is of type "Float". -The problem I found is due the ty
    Author: am35 am35     Date: 3/8/2011     Section: Forum
  • connecting to oracle datasource
    Umm, I have been working with a SQL 2005 and ORACLE 10g and my solution to your problem is to use linked server and OPENQUERY. The steps are: 1.Install the ORACLE Client on the server (if u use 64 bit windows sever then install the 32 bit client then the
    Author: Hyblade Hyblade     Date: 3/1/2011     Section: Forum
    tags : SSIS
  • Crescent IT Solutions Offers Online Training & Placement on all Software related Business Courses
    Crescent IT Solutions which is a high profiled Training Institute offers you SAP(All Modules), Oracle Applications, People Soft, MS.NET, JAVA, QA Testing, QTP, TIBCO, SQL Server, Data warehousing, Business Analyst, PHP, Online Training for the students wh
    Author: crescentitsolutions crescentitsolutions     Date: 2/24/2012     Section: Blog
  • Flat File to Oracle through SSIS
    Guys, I thought there is no special way, just use Source (Flat File) and destination is my Oracle DB. Everything is looks ok before i run my package. I test my both connection Flat File and Oracle DB Works fine. After i hit F5 i am having these error. 1)
    Author: tooba tooba     Date: 12/21/2011     Section: Forum
  • connecting to oracle datasource
    Use the Oracle provider if you install the Oracle client. I always use the Oracle provider. Install Oracle 10g Release 2 64-bit client software (available from Oracle website) Install Oracle 10g Release 2 64-bit ODAC software (available from Oracle websit
    Author: m3crast m3crast     Date: 3/2/2011     Section: Forum
  • Step Error Description:Catastrophic failure
    reymon26 said: This is a dts package that transfer data from the oracle database to the sql server database. i have attached the screenshot of the dts package.. Do I need to do anything to see this scrshot ? Coz I can't see it yet (I'm a newb) Anyway base
    Author: Hyblade Hyblade     Date: 3/2/2011     Section: Forum
    tags : SSIS, ORACLE
  • Help with Oracle Connection
    I have a set of SSIS Packages which connects to Oracle source using MSDAORA (Microsoft OLEDB Provider for Oracle).I have added a new package to the project by copying and renaming an existing object. When I run this new package I get the following error &
    Author: Yuvaraj Yuvaraj     Date: 6/13/2011     Section: Forum
  • oracle data source input in SSIS
    Thanks a lot. I think i can upgrade the client on my system but will have to go through a long procedure to get it done. This package was originally written in DTS and uses a "microsoft oledb provider for oracle" to connect to the oracle data source. I ha
    Author: am35 am35     Date: 3/9/2011     Section: Forum
  • How to connect Oracle Server (not local) ?
    Hi Komaty, What OS are you using? Please have a look at the following link, it may be because of SSIS integration with 32/64 bit providers. http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx BIDS is a 32
    Author: ChrisSchmidt ChrisSchmidt     Date: 12/5/2012     Section: Forum
    tags : ORACLE
  • oracle data source input in SSIS
    Thank you. I will try to cast the oracle input and check if it works fine. The sql server 2000 server is in 32 bit environment. I am not sure what the environment of sqls erver 2008 will be. I have also found this artcile at msdn which gives information a
    Author: am35 am35     Date: 3/9/2011     Section: Forum
  • SQL Server New Version Denali - New Feature Sequence
    SQL Server New Version Denali - New Feature Sequence One of the new featured in SQL Server 2011 – Denali is Sequence. Whoever have worked in Oracle or DB2 can easily connect to this feature and it is in the SQL Server wishlist for long time. While m
    Author: pkumar3 pkumar3     Date: 10/18/2012     Section: Blog
  • Authentication from Plumtree
    We will not be upgrading to the Oracle product. I have some sample code that I am working with from: http://forums.oracle.com/forums/thread.jspa?threadID=822449&tstart=122 but it was built for 2005 using IIS.
    Author: syale syale     Date: 6/5/2011     Section: Forum
  • Connect to Oracle 11i in SSIS
    We had a working SSIS package, that was connecting to Oracle 9g and getting some data for us. After the Oracle server was upgraded to 11i , we updated the tnsnames.ora pointing to the new connection. Using SQL Plus we were able to connect to the new host,
    Author: jkminder jkminder     Date: 9/26/2011     Section: Forum
  • oracle data source input in SSIS
    Hi All, I am using an SSIS 2008 package to load data from an oracle datasource into a sql server 2000. I am using a oracle oledb provider for oracle to connect to oracle data source. I am able to sucessfully connect and get the input data. But I am gettin
    Author: am35 am35     Date: 3/7/2011     Section: Forum
  • connecting to oracle datasource
    Thank you for your reply. I was trying to understand what i need to do here. So, I need to install the oracle client on my local system(as I am still developing on my system)?And I need to install both 32 bt and 64bit installation for oracle on my system?
    Author: am35 am35     Date: 3/2/2011     Section: Forum
  • Bulk Load - SSIS ( column conversion)
    use conditional Splits: http://www.bidn.com/blogs/devinknight/ssis/80/better-know-a-ssis-transform-conditional-split for oracle specific converstions: http://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_2036.htm http://www.techonthenet.com/o
    Author: Toufeeq Toufeeq     Date: 9/4/2012     Section: Forum