SentryOne Adds New Features to CodeSlice SSIS Scripting Tool
Like many modern Agile product development environments, the SentryOne product team typically works in two- to three-week cycles on a preplanned set of work. Each cycle is referred to as a sprint. After each sprint is completed, there is typically a sprint review, where the accomplished work is presented to the company, followed by sprint planning, which ignites the cycle all over again.
While this methodology is great for iteration, project scope definition, and frequent releases, it can be easy to fall victim to sprint fatigue. I’ll save you the gruesome productivity-killing details, but this can sometimes lead to things like burnout or, my biggest fear, lack of enthusiasm and sense of ownership for the products you’re building. The bottom line is that a happy, healthy, and motivated product development team is a productive product development team.
At SentryOne, we strive to prioritize employee wellness in a multitude of ways, such as our onsite fitness facility, a wellness stipend, catered Friday lunches, a beer or two on tap (okay, five), just to name a few. But I digress; this isn’t meant to be an HR recruitment blog.
To further this effort and to tap into the creativity of our incredibly talented engineering force, we held our first annual Innovation Sprint. During this unique sprint, our engineers were encouraged to team up with engineers outside of their typical team to deliver a project that they were passionate about that also added value to the company. While this was my first time participating in an Innovation Sprint, I’m confident that this breath of fresh air could benefit a lot of engineering departments and cultivate innovation for any company.
CodeSlice, a community favorite and free SentryOne tool, was updated with new features and fixes during this Innovation Sprint, and I’m excited to share them here.
What Is CodeSlice?
CodeSlice is a free Visual Studio extension that allows BI developers to quickly and easily insert template-based script tasks and components into their SQL Server Integration Services (SSIS) packages. It can also be used to generate and compile simple SSIS scripts for use within SSIS packages. The slices utilize the native script task and components in SSIS but allow for users that are not 100% comfortable with programming languages to use them seamlessly.
Selecting a slice within CodeSlice
The enhancements that were made to CodeSlice during the Innovation Sprint make this tool much more powerful while supporting the latest and greatest technologies. The new features include:
- SQL Server Data Tools (SSDT) for Visual Studio 2015, 2017, and 2019 support
- SSIS 2016, 2017, and 2019 support
- Target Server Version support
- CodeSlice now intelligently compiles scripts using the correct TargetServerVersion’s script language
- New Execute PowerShell Script slice
- New File Compression slice
- New File Decompression slice
- New Minimal Script Task slice
In addition to new slices and SSIS and SSDT support, the team made updates to CodeSlice to address a few specific needs, including:
- Boolean Parameters are now correctly updated within compiled scripts.
- Parameter bindings are no longer disabled when the current slice supports that binding.
- The ability to move variables between available, read-only, and read-write is now working as expected.
You can view the complete change list here.
How Do I Download CodeSlice?
If you’re interested in trying out the CodeSlice Visual Studio extension, you can download it here.
If you’ve already downloaded CodeSlice, you can learn how to update to the latest version here.
For installation instructions and software and system requirement information, be sure to check out the SentryOne CodeSlice help documentation.
Tyler is an Associate Technical Product Manager, assisting in the development and delivery of the SentryOne Data DevOps product portfolio. After working as a software developer for almost two years, he transitioned to Product Management with a desire to be more directly involved with SentryOne customers and to leverage the technical experience he's gained to understand the problems and solutions in the industry better. He is thrilled to be a part of the next generation that is committing to improving the lives of the Microsoft Data Professional.