November 2007 - Posts

• SSIS Multicast and Trash or Separate and Union?

  Today I was optimizing a package that handles a very common topic: process some rows and send all them to a flow but, for some of them, make additional processing. A simple Multicast and a Conditional Split solve the problem, the picture explains it better Read More... Posted Thursday, November 15, 2007 2:15 PM by AlbertoFerrari | 2 Comments Filed under: SSIS

• Visio and SQL Extended Properties: a tool to marry them

  Visio database models have column descriptions, SQL Server has extended properties where to store them but, even if they share the same producer, it seems that Visio is unable to store column descriptions in extended properties so that other tools can Read More... Posted Wednesday, November 07, 2007 12:00 PM by AlbertoFerrari | 4 Comments Filed under: SQL, SQL Server