I would like to see the ability to Execute an SSRS report from SSIS. This way when data is loaded and successful, the reports can automatically be run and then possibly emailed to the user in one single process vs having seperate ETL and Report jobs run.51 votes
When you export the results of the Best Practice Analyzer it only includes column for "Severity", "Name" and "Path". This doesn't tell you important pieces of information like the name of the project that is affected, the name of the package that is affected or the name of the best practice that was violated. Without that info, the export is pretty much useless.44 votes
In the 2017.4 release, the Best Practices Result Export now includes the rule that was violated and the recommendation. The path value reflects what object (package, task, component) violated the rule.
We are still in process on adding the root item to the export, but this should be included in the next release. The root item is the starting point for the scan, and could be a specific package, a project, a database, or an entire SQL Server.
Have a checkbox in the deployment utility that will create a msi installation file for my packages. Very common that developers are not permitted to deploy and to have a package that can depoy all changes that can be handed to DBA would be great.33 votes
Great feature request. We will consider this for future version where you can compile exe/msi file which can be easily sent to DBA if you dont have access to PROD environment
Add an option to apply the same chosen action across all columns. Will save MUCH time as opposed to choosing the same option for each column.17 votes
This feature was already in our road map but getting many votes put this to higher priority so hopefully you will get this feature in next build.
Thanks for using uservoice
Create a tool for updating object extended properties. Most common property for SQL Object is Description but allow to add other Properties to selected objects .. e.g. Owner , ContactInfo etc.4 votes
Be able to design your own expression snippets like you can with script snippets that can be saved and used multiple times.3 votes
Allow you to logically group a set of packages.
We have lots of packages for our ETL load and we would like to group them to see them as a whole.1 vote
This is being investigated for our Fall 2014 release.
When you display the packages in tree-view on Right hand side and left hand side, may be using COLOR coding (Red, Green,BLUE) may be helpful, and display which packages are alredy existing in Destination folder compared to SOURCE. Visual COLOR difference can be helpful. More like "WinDIff" functionality0 votes
- Don't see your idea?