BIML

Fully automate the BIML expansion

Posted on

With all the BIML code done and the production scenarios start to emerge, it would be great to have the BIML code automatic expanded and create new packages if there are changes to the underlying metadata. Either configured manually or directly from the sources. With the MIST application from Varigence – this is possible through the command line util that ships with the installation.

Database

SSISDB crash – Certificate, asymmetric key or private key data invalid

Posted on

One of my longterm customers had a database-server crash a while ago. The server would not spin up after reboot. The whole installation including tweeks and other stuff had to be re-attached to a new and fresh installation of SQL Server 2012. It was s fairly young BI-server, so the damage was not that big after all. Untill today…