Back in November I posted about the 1.2 release of the amazing BIDS Helper project on CodePlex and the new SSIS-related features it included. Well, the folks who contribute to the BIDS Helper project have been hard at work getting ready for their 1.3 release, and today they checked into TFS the first set of features designed to provide real-world deployment capabilities from within the Visual Studio (BIDS) development environment.
Now, not only can you create the standard deployment manifest you can also deploy automatically and (here’s the exciting part!) have BIDS Helper automatically create a batch file that calls DTUTIL each time you build your project.
How cool is that!
The reason I’m so excited about low-tech batch files is that they are incredibly simple to integrate into any deployment process, and they’re completely hands-free. They may not be sexy, but they’re close to perfect nonetheless.
Take a look here for more information: http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Deploy SSIS Packages
The bad news is that version 1.3 is not yet ready for release, so if you want to start taking advantage of this functionality you will need to download the BIDS Helper source code and compile it yourself. Which I am now about to do…
 Which seems like a good start, but quickly becomes a dead-end, because it is dependent on a user clicking and typing every time it is used, which makes it very undesirable in a real-world deployment scenario.