November 2011 - Posts

• IBM DB2 and the “'DbProviderFactories' section can only appear once per config” error

  IBM doesn’t like MS. That’s a fact. And that’s why you can get your machine.config file (!!!) corrupted if you try to install IBM DB2 data providers on your server machine. If at some point, after having installed IBM DB2 data providers your SSIS packages Read More... Posted Thursday, November 24, 2011 7:31 PM by Davide Mauri | 4 Comments

• Execute a SSIS package in Sync or Async mode from SQL Server 2012

  Today I had to schedule a package stored in the shiny new SSIS Catalog store that can be enabled with SQL Server 2012. ( http://msdn.microsoft.com/en-us/library/hh479588(v=SQL.110).aspx ) Once your packages are stored here, they will be executed using Read More... Posted Thursday, November 24, 2011 6:45 PM by Davide Mauri | 3 Comments Filed under: SSIS, SQL Server, 2012

• DAX editor for SQL Server

  One of the major criticism to DAX is the lack of a decent editor and more in general of a dedicated IDE, like the one we have for T-SQL or MDX. Well, this is no more true. On Codeplex a very interesting an promising Visual Studio 2010 extension has been Read More... Posted Wednesday, November 23, 2011 8:58 AM by Davide Mauri | 1 Comments Filed under: SQL Server, DAX, 2012, Visual Studio