Welcome to EMC Consulting Blogs

Browse by Tags

• Data Warehouse
• ODBC
• RetainSameConnection
• SP2

• SSIS RetainSameConnection bug and SP2

  We have an AS400 source system and can only use ODBC connections to access it. We also need to set RetainSameConnection to true since we're initializing the AS400 connection with a number of temporary aliases that will be used by later Data Flows Read More... Posted 06 September 2006 10:34 by Kristian.Wedberg | 0 Comments Filed under: SSIS, ODBC, SP2, RetainSameConnection

• 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 | 5 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

• SSIS lookup transform gotcha

  We recently used the lookup transform to retrieve foreign keys in a data warehouse project, and were plain lucky to notice the following issue: When looking up padded varchar strings, the records the lookup transform considers equal differs depending Read More... Posted 22 February 2006 16:43 by Kristian.Wedberg | 21 Comments Filed under: SSIS