SSIS with BidsHelper-Getting into BIML
SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, there are some painful shortcomings in the toolset that make it difficult to automate package creation, easily reuse patterns and templates, create packages directly from schema information and other metadata, and work with others on the same solution.
The free and open source BIDS Helper Add-In (http://bidshelper.codeplex.com) solves many common issues with BI development, and this is no exception. BIDS Helper now offers support for automatically generating SSIS packages using the Business Intelligence Markup Language (Biml). Biml is an XML-based language that allows you to describe your BI solution in a declarative fashion, similarly to using HTML to describe how a web page should appear. In addition, you can embed BimlScript (C# or VB.NET code) into Biml, in the same way that ASP.NET works with HTML. This allows for large numbers of packages to be created with a minimal amount of code. Create the pattern or script once, and use it many times – or share it with your colleagues and the community. Best of all, the Biml language has an open specification and can be used for free from tools like BIDS Helper.
Varigence provides tools, frameworks, and services that advance the state of the art in business intelligence by building abstraction and productivity capabilities to extend the Microsoft Business Intelligence technologies.
Varigence was founded as a privately held company in 2008 with headquarters in Greenville, SC and offices in Seattle, WA.
Employing a mix of deep experience in developer tools, business intelligence, and consumer software products, Varigence applies the best innovations from application development to enterprise business intelligence while offering an unprecedented level of accessibility to the end-user.
Varigence currently offers two tools: Mist/Biml and Vivid. Mist/Biml is about accelerating business intelligence development. Vivid is an Excel addin that will make anyone using PowerPivot or cubes in Excel more productive.
Varigence also provides consulting, contracting, and training services. We have delivered state-of-the-art business intelligence solutions to companies of all sizes, from internet startups and Fortune 100 companies.