blogs.conchango.com

March 2006 - Posts

• SSIS and “Cursor Operation Conflict”

  Watch out for this feature, not a bug thingy: In a Data Flow Task, my OLE DB Destination started to fail intermittently for no appearent reason. The error message was "Cursor Operation Conflict". Some head scratching later I discovered that the SQL Server Read More... Posted 08 March 2006 18:27 by Kristian.Wedberg | 1 Comments Filed under: SSIS

• Database Snapshots and SSIS

  Did you think SQL Server 2005 database snapshots were really cool, but wondered how useful they were in practice? Building a Data Warehouse, here's an ideal use for them: In my current project we're extracting data for the data warehouse from several Read More... Posted 06 March 2006 18:45 by Kristian.Wedberg | 2 Comments Filed under: SSIS, Data Warehouse