BIDS Helper 1.2 Released

BIDS Helper is a CodePlex project that delivers a set of Visual Studio add-ins for developers working on BI projects. It’s been around for a while, but until now has not had any SSIS-focused features.

Until now!

The BIDS Helper team has just released version 1.2 of their tool, and it now includes (in addition to a bunch of SSAS-related stuff as well) these new SSIS features:

  • Create Fixed Width Columns – Simplifies the definition of a fixed width flat file connection manager
  • dtsConfig File Formatter – As far as I can tell, this is just another shortcut for the ctrl-k, ctrl-d “prettify” keyboard chord that is built into Visual Studio
  • Expression and Configuration Highlighter – Color-codes tasks and connection managers that have properties set by configurations or expressions, making your packages more self-documenting.
  • Expression List – Adds a new “Expression List” window to Visual Studio’s “Other Windows” menu; this window displays all expressions defined within the package.
  • Smart Diff – Provides a pre-processor for the built-in VSS or TFS differencing tools, to make it easier to diff two DTSX files’ XML content.

All in all, this looks like a major step forward in the SSIS developer’s toolbox. The Expression and Configuration Highlighter and Smart Diff features in particular provide functionality I have often wanted, and even if they’re not exactly what I would have liked, they’re still better than what we had before. Check it out!


About ssimagine

My name is Matthew Roche, and I am a Senior Program Manager with the SQL Server product group at Microsoft. I work on Master Data Services and Data Quality Services, and have previously worked on SQL Server Integration Services. Although I work for Microsoft and will be posting on technical topics, I want to stress that this is a personal blog, and any opinions posted here are mine and mine alone. I built my career around SQL Server and Microsoft technologies for well over a decade before I joined Microsoft as an employee, and I plan on using this blog to share my personal experience and opinions. They may well be shaped by my experience on the SQL Server team, but they’re still mine, and not that of Microsoft, disclaimer, disclaimer, etc., etc..
This entry was posted in BI, dev, SQL Server, SSIS, tools. Bookmark the permalink.

2 Responses to BIDS Helper 1.2 Released

  1. Hi Matthew, If you have any idea for improving anything in BIDSHelper or if you have any ideas for new features feel free to add items to the task list or to send me an email

  2. Thanks, Darren. I do have a few ideas, but it will probably be a few weeks before I can get them into a coherent form to share. Work is kind of crazy these days, but when I have time to breathe I’ll post them as work items on CodePlex.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s