Welcome to EMC Consulting Blogs

Browse by Tags

• IBM
• Inane Waffle
• Microsoft
• Nugget
• ole db source adapter
• pl-sql
• security
• SQL Server
• SQL Server Integration Services
• SSIS
• T-SQL
• visio

• String Aggregation in T-SQL & PL-SQL : SQL Nugget

  In my current day job I’m doing a lot of work against an Oracle back-end and I’ve just come across a situation where I need to do some string aggregation. Effectively I needed to turn this: Parent Child Charles William Charles Harry Anne Peter Anne Zara Read More... Posted 16 July 2009 13:32 by jamie.thomson | 6 Comments Filed under: SQL Server, Oracle, T-SQL, Nugget, pl-sql

• Encountered a fatal error during reverse engineer of information from the database (Oracle to Visio) - fixed

  Quick one this. Today I've been attempting to reverse engineer some database objects from an Oracle 10G server into Microsoft Visio 2003 but it was failing with this rather nasty and useless error message: As with many such problems the cause of this Read More... Posted 07 January 2009 11:48 by jamie.thomson | 0 Comments Filed under: Oracle, visio

• SSIS: Connecting to Oracle just got a whole lot better

  There was some great news this week for SSIS developers that are building solutions involving databases other than SQL Server; Microsoft will, later this year, be releasing new connectors for Oracle, Teradata and SAP BW. Check out Darvey Lavender's announcement Read More... Posted 14 March 2008 19:41 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, Oracle

• Is SQL Server more secure than Oracle?

  Well David Litchfield thinks so. "Who he?" you ask. Well this article will explain all. Thanks to Dan Jones for the link. -Jamie Read More... Posted 07 June 2007 20:53 by jamie.thomson | 0 Comments Filed under: SQL Server, Oracle, security

• Oracle pricing titbit

  I spotted this on El Reg earlier on today. Apparently Oracle is going to be sold on a per-socket basis rather than per-core thus aping Microsoft's policy with SQL Server. Seems like a good move for Oracle - it should enable them to compete better Read More... Posted 07 March 2007 01:59 by jamie.thomson | 2 Comments Filed under: SQL Server, Oracle

• SSIS: Comparison of Oracle Warehouse Builder and SSIS

  I'm posting this largely as a future reminder to myself but in case anyone is interested TDWI have posted a comparison of SSIS and Oracle Warehouse Builder . The article also makes a nod towards comparisons with pureplay vendors such as Informatica Read More... Posted 11 October 2006 07:04 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS, Oracle

• OLE DB: Cannot connect using Microsoft OLE DB Provider for Oracle

  I've had a nasty little problem today and thought it was worth sharing. I've been trying to use the Microsoft OLE DB Provider for Oracle to connect to some Oracle databases but it was failing with the error: "Test connection failed because Read More... Posted 19 September 2006 23:24 by jamie.thomson | 6 Comments Filed under: Inane Waffle, Oracle

• SSIS: Persistent Oracle Connector

  Those of you that are using SSIS in conjunction with Oracle will have (or should have) read Donald Farmer's blog post that details some of the issues that you need to be aware of. Donald himself states "I do not expect that Microsoft will write an Oracle Read More... Posted 07 April 2006 13:06 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SSIS, Oracle

• SSIS: Loading to Oracle

  Many customers are unhappy that SSIS performance is slow slow slow when inserting to Oracle. Donald Farmer sets outs a few of the reasons for this here: http://www.sqljunkies.com/WebLog/donald_farmer/archive/2005/03/13/8819.aspx A guy called Scott Barrett Read More... Posted 15 November 2005 06:59 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Oracle

• SSIS: Connect to Oracle

  Most of the stuff I put up here is to share knowledge around a bit but every so often I use it as a dumping ground for little titbits that I don't want to forget in the future. This is one such occasion. I've been trying to access data in Oracle from Read More... Posted 25 October 2005 11:58 by jamie.thomson | 30 Comments Filed under: SQL Server Integration Services, SSIS, ole db source adapter, Oracle