BI xPress Release Notes

v2020

Version 2020.1.1 [January 28, 2020]

Features

• Feature 44240: Added support for 2019 SQL Server and 2019 Visual Studio.

v2019

Version 2019.1.1 [February 4, 2019]

Fixes

• Fix 45521: Extract / Load Detail Report Missing Data
  • Reapplying the auditing framework to packages is needed for the missing data to begin to populate the Extract / Load Detail report
• Fix 45139: SSIS Catalog Import creates Blocking SQL statements when importing large catalogs

v2018

Version 2018.5.1 [December 4, 2018]

New Features

• New 44463: LicenseManager now uses verb based command line format

Fixes

• Fix 43131: Monitoring Console can throw "SynchronizationLockException: The write lock is being released without being held" error when selecting package execution
• Fix 44591: SSIS Catalog Import crashes when attempting to import into a BI xPress database it cannot connect to
• Fix 45760: System Dashboard throws System.ArgumentException: A route named 'TestCoverageReportsForObjectPaths' could not be found in the route collection.
• Fix 42906: Workbench Server installer throws "SentryOne Software Group Policy Manager has stopped working" error

Version 2018.2.3 [April 27, 2018]

Updated Features

• Update 1918: Improved Variable and Parameter Dependency Scanner
  • Used / unused variables and parameters are now organized by their respective package scope
  • Dependencies present within a data flow component's input and output columns are now included
• Update 7886: Monitoring Console now includes package execution status filters
  • Monitoring Console can now filter package executions based on the execution's status
  • Users can now exclude or include successful, running or failed executions within the package execution

Fixes

• Fix 1783: Package Builder does not provide meaningful message when attempting to apply parameters to unsupported package properties
• Fix 11008: Purge Database does not check for required stored procedures before attempting to purge
• Fix 14045: Within Workbench Auditing Framework, checking / unchecking Warning Filters does not enable the save button
  Fix 14046: Within Workbench Auditing Framework, project parameters and connection managers are only added to the first project when applying to multiple packages that span different projects
• Fix 16296: Visual Studio Extension uninstaller displays multiple check boxes for the same version of Visual Studio
• Fix 16357: Best Practice's help documentation for command line arguments does not include all supported SSIS versions
• Fix 16399: Within Workbench, Configuration Manger does not properly decrypt any encrypted configuration values
• Fix 16339: Workbench Update Advisor shows 'Updated software is available' on latest version

Version 2018.1.4 [February 8, 2018]

New Features

• New 4629: BI xPress extensions now support initializing logging through external configuration files
• New 15202: BI xPress Extension support for Visual Studio 2017

Fixes

• Fix 14591: Best Practices Analysis Result Export does not include solution item information
• Fix 14659: Auditing Framework within Workbench prompts for a package's password multiple times
• Fix 16093: Error when creating BI xPress database on SQL 2008R2 - "'CONCAT' is not a recognized built-in function name."

v2017

Version 2017.4.5 [November 6, 2017]

New Features

• New 10922: All background Monitoring Console activity should cease when presenting a modal settings or purge database dialog
• New 11116: Monitoring Dashboard now includes Extract and Load Row aggregation for Data Flows
• New 11665: At start of package execution, BI xPress extension no longer causes Visual Studio to pop-up all BI xPress panels
• New 12365: BI xPress Extension now supports SSDT 2017 within Visual Studio 2015 with or without the SSIS 2017 runtime installed
  • Currently, users need to have the full SSIS 2017 runtime installed in order to manipulate SSIS 2017 packages. Users should be able to manipulate packages with just the SSDT 2017 installed.
• New 12550: Best Practices Analysis Result Export now includes the rule that was violated and recommendation
  • Currently the Result Export doesn't have any identifying information regarding what rule was violated and where. It would be a good idea to include that to help make the export actually useful to the customers
• New 13522: Improved performance within SsisCatalogPackageExecution table

Updated Features

• Update 11626: Monitoring Console now includes filters for excluding errored, running, and succeeded executions
• Update 12468: As of 2017.4, SentryOne no longer supports Data Nugget
• Update 11979: Online help documentation now includes a rolling list of release notes that include all product release notes within a single file
• Update 10376: For better clarification, Licensing Registry and Deactivation buttons have been moved

Fixes

• Fix 10307: Report Mover's recommended target full path is cutting off characters
• Fix 10374: Auditing Framework throws "object name is not valid" error when using an existing connection that includes non-alphanumeric characters
• Fix 10950: Warning Filters do not refresh when using an existing connection manager from within Visual Studio.
• Fix 10953: BI xPress Extension information does not show up within the "Installed Products" section of the "About Microsoft Visual Studio" page
• Fix 11034: Components within containers are displayed even when the container is collapsed
• Fix 11649: Tasks that fail within a Group cause the group to show an invalid runtime
• Fix 11986: Variable Usage scanning is not showing dependencies
• Fix 12020: Configuration Manager Wizard incorrectly views "\" in connection string name for "."
• Fix 12024: Monitoring Console treats execution range filters as an AND relationship
• Fix 12025: Annotations within a Data Flow are removed by SSDT when Auditing Framework is removed
• Fix 12442: Report Mover downloads duplicate dependencies causing slow operation
• Fix 12461: Auditing Framework does not add project level parameters and conneciton managers when using the SSIS Solution package location option
• Fix 12567: Auditing Framework does not load SSIS Catalog
• Fix 13047: Refresh SSIS Catalog button within Auditing Framework currently does not work
• Fix 13076: Variable Toolbar buttons sometimes did not appear within the BI xPress VS2015 Extension
• Fix 13109: When connecting to an SSRS 2016 Report Server that contains Mobile Reports, Report Mover throws "MobileReport is not a valid enum value."
• Fix 13959: BIxPress Auditing Framework throws runtime error when sensitive parameters are present
• Fix 13979: Report Mover crashes when attempting to deploy a report to a lower server version server

Version 2017.3.3 [August 7, 2017]

New Features

• New 11676: Add support for SSIS 2017 targeting with existing feature set to BI xPress and BI xPress Server
• New 12378: User Defined Best Practices' path evaluator can now be manually edited
• New 2846: Licensing now works within environments that use FIPS compliant algorithms for encryption

Updated Features

• Update 11115: Auditing framework now includes ability to reopen packages upon completion
  • Allows users to quickly apply the auditing framework to multiple open packages without being prompted by Visual Studio to reload
  • On occasion, after applying the Auditing Framework Visual Studio will stop displaying package executions. If you are experiencing this behavior, use this feature
• Update 11978: License activator now includes a "Copy Details to Clipboard" button

Fixes

• Fix 1627: Package executions that contain errors, but are still running can't be marked as stopped
• Fix 11045: Within Visual Studio 2015 Extension, the package layout information is not being captured for OnSave events
• Fix 11162: Auditing, Notification, and Deployment Wizards do not display the correct SSIS version in title bar
• Fix 11176: BI xPress does not detect the SSIS Versions when only SSDT is installed
• Fix 11198: Attempt to parse the expression "@[User::varSSISOps_DisableVarLogging]==true && @[User::varSSISOps_DisableConnLogging]==true" failed
• Fix 11558: Auditing Framework - Selecting Project in Workbench crashes Workbench
• Fix 11599: After package execution, Notification Framework Event log displays "The description for Event ID 0 from source BI xPress cannot be found"
• Fix 11620: The data types nvarchar(max) and ntext are incompatible in the equal to operator.
• Fix 11628: Notification Framework improperly detects SSIS version
• Fix 11629: Latest variable values sometimes do not show up within the Monitoring Console
• Fix 11640: Variable masking does not mask parameter values and some wildcard scenarios don't work
• Fix 11694: When connecting to an SSRS 2016 Report Server that contains KPIs, Report Mover throws "KPI is not a valid enum value."
• Fix 11984: Configuration Manager shows password when you hover.
• Fix 12022: The expression for variable "varSSISOps_DisableParameterInitialValueLogging" failed evaluation. There was an error in the expression.
• Fix 12023: Opening Monitoring Console: Conversion failed when converting from a character string to uniqueidentifier
• Fix 12403: Denied Access to registry key "HKEY_CURRENT_USER"

Version 2017.2.3 [May 1, 2017]

New Features

• New 9070: MaxVarCharsToLog has been parameterized and configurable when viewing within the Monitoring Console
• New 9176: Purge Database Wizard offers a start and end date instead of Days To Start and Days To Keep
  • The purge database wizard now offers users a start date and an end date to constrict the purging of SSIS Package Executions. The underlying stored procedure remains the same and has not changed, only the user experience. For those that need to determine the DaysToStart and DaysToKeep parameters for SQL Agent Jobs or stored procedures, hovering over the start and end date boxes within the UI will provide that data.
• New 9178: Snippet Wizard is now available when right-clicking in the Control Flow or Event Handlers view of BI xPress SSDT Extension

Updated Features

• Update 9148: BI xPress Help File now includes addtional info on BI xPress database updates
• Update 9179: Auditing Framework within Workbench now includes validation warnings
• Update 9246: The "View Packages in Visual Studio" button is no longer available
• Update 9838: Package Builder Wizard's "New Template (From Selection)" and "Modify Packages (From Selection)" now available in Visual Studio 2015
• Update 9864: Snippet Wizard's help documentation now includes note that it only operates on one SSIS package at a time
• Update 10313: Package Deployment's help documentation now includes limitation on being unable to deploy packages to the SSIS Package Catalog
• Update 10337: Quick Status View is now available in BI xPress Visual Studio 2015 Extension

Fixes

• Fix 9150: "An Item with the same key has already been added" error when applying the auditing framework to a package that contains identically named components
• Fix 9177: Modifications by BI xPress may not be applied correctly if there are unsaved changes within SSDT 2016 / Visual Studio 2015.
• Fix 9197: Data Flow Tasks for some packages are not showing the row counts
• Fix 9258: Project files are no longer included in the selected packages list when right-clicking on a project within BI xPress Extension for Visual Studio 2015
• Fix 9259: Error: Unable to cast object of type 'System.Collections.ObjectModel.Collection'1[PW.Common.AuditWarning]' to type 'System.Collections.Generic.List'1
• Fix 9827: Deployment Wizard persists previously selected packages
• Fix 9851: Variables values are now appearing correctly when viewing the package execution during and after execution.
• Fix 9863: BI xPress Add-in does not show the correct SSIS version for packages when selecting an SSIS Project that uses TargetServerVersion
• Fix 9866: The Variable Expression buttons disappear when changing the Grid Settings to show all package variables
• Fix 10252: Package and Project Parameters aren't being accessed when Notificaton Engine is applied to SSIS packages
• Fix 10279: When browsing for existing BI xPress databases from within the Workbench Plugin, selecting a different server changes the existing database name and may throw a "cannot connect" warning
• Fix 10286: Package executions imported from the SSIS Catalog are not seen as the same package in the Monitoring Console Dashboards
• Fix 10301: Within SSIS 2005 and 2008, Deployment Wizard throws 'Overload resolution failed because no accessible "PopulateMSDBPackagesInfo"...' error
• Fix 10318: Groups within the Control Flow and Data Flow do not appear after applying the Auditing Framework to a 2012 or later package
• Fix 10322: Using a touch screen with the Monitoring Dashboard causes Workbench to crash.
• Fix 10325: Error report submission fails with redirect message
• Fix 10326: Could not apply auditing framework to lower version packages with SSDT 2015 installed
• Fix 10327: Applying the Auditing Framework from Workbench causes "Can not log connection. Re-applying BIxPress Auditing Framework may fix this issue" warning during execution
• Fix 10347: "Latest x executions" not showing more than the latest 20 entries when x is > 100,000
• Fix 10348: Entering over 10,000,000,000 executions in the Options menu of Monitoring Dashboard crashes the Workbench
• Fix 10349: Monitoring Dashboard doesn't show any packages when you select the "Ungrouped" group in the Group Filtering
• Fix 10366: Marking a package execution as stopped does not update the control flow and data flow tasks
• Fix 10373: Using package parameters for Package Deployment projects uses the BI xPress database specified in the wizard, not the server/database/username/password defined in the connection manager.
• Fix 10977: In the Package & Task Performance report, when Execution Mode is set to anything other than "Interactive" it throws "An error occurred when retrieving the report data: Value cannot be null. Parameter name: s" error
• Fix 11073: When "Object Variable Logging" is disabled, applying the Auditing Framework throws a "Failed to create OnVariableChanged handler: Value does not fall within the expected range"
• Fix 9839: Unable to install two versions of Workbench on the same machine.

Version 2017.1.3 [February 2, 2017]

New Features

• New 7814: Date formatting within Monitoring Console Reports are now consistent across all reports
• New 8287: Individual Alerts now included when using the Notification Engine to connect to a BI xPress Server
  • Users must reapply the Notification Engine to their SSIS packages to enable the new behavior of including alerts (warnings and errors) that they have opted to be notified about.
• New 8327: Added Filtering Options to the Package Deployment Wizard
  • Users now have the ability to filter files and folders within the explorer window of the package deployment wizard.

Updated Features

• Update 1483: Best Practice Analyzer Report now groups results in a more logical manner
• Update 1486: Best Practice Analyzer now groups rules based on which technology it applies to
  • BI xPress orders best practice rules based on technology type first. Making it easier to find applicable rules as user can collapse irrelevant rules.
• Update 6832: Visual Studio 2015 extension now supports targeting lower server versions for SSIS packages
  • The BI xPress Visual Studio 2015 Extension now supports usage within SSIS projects with the TargetServerVersion set to SQL Server 2012, 2014, and 2016.
• Update 8739: Improved product version logging at start up
• Update 7430: Help page now includes a button for each installed product that launches local help documentation
• Update 8755: Help documentation for System Requirements, Permissions and Setup for BI xPress, DBA xPress, DOC xPress and LegiTest combined
  • Since BI xPress, DBA xPress, DOC xPress and LegiTest are all installed within the same Workbench installer, including the system requirements, permissions and setup for the other products within each individual help documentation can help with setup 

Fixes

• Fix 1400: Switching the connection for data generation clears all current content
• Fix 6699: The Auditing Framework does not log the initial values of variables and parameters
• Fix 7887: BI xPress Notification Framework settings does not save when clicking finish and restarting Visual Studio
• Fix 8239: Purging the BI xPress repository when using optional Package or Machine name leaves orphaned executions
• Fix 8331: Notification Engine's Server Integration does not correctly encode special characters
• Fix 8333: During a custom installation, the BIxPress Extension will not install if LegiTest Extension is excluded
• Fix 8688: Fix typo within Auditing Framework activity log message
• Fix 8715: Report Mover does not retain relative folder structure within target server
• Fix 8752: After using the SSIS Catalog Import, the Package Performance report throws "Conversion failed when converting from a character string to uniqueidentifier" error
• Fix 8770: BI xPress Extension no longer throws an error when installed on a machine with just SSDT 2015
• Fix 8775: Creating a new BI xPress database doesn't update the preferences to reference the new connection string
• Fix 9199: BI xPress Visual Studio Extension throws an exception upon VS startup regarding licensing
• Fix 9142: The license expiration date does not appear in the License Manager

v2016

Version 2016.4.5 [October 25, 2016]

New Features

• New 1044: Users can now apply / remove the audit framework from packages deployed to the SSIS Catalog using Workbench
  • When Audit Framework is launched from inside Workbench, users have the option of choosing the SSIS Catalog as the source for packages.
• New 4653: Auditing Framework within Workbench now includes Warning Filtering
  • Warning filtering enables users the ability to exclude specific warnings from logging. Excluding warnings improves package execution times and lower database use. It also reduces logging clutter by only logging messages important to the user.
• New 6758: The scan variable dependency, expression editor, and expression library are now available within SSDT for Visual Studio 2015

Updated Features

• Update 4731: Auditing Framework's package password and version selector dialog is easier to use.
  • The package password and version selector dialog now only shows the password column if it is needed. 

Fixes

• Fix 1402: Data Generation doesn't include a "Done" option when editing an existing data provider.
• Fix 6277: An erroneous tooltip no longer appears when hovering over variables within the SSIS Monitoring Console.
• Fix 6730: When reapplying the Auditing Framework, if necessary, BI xPress now correctly re-applies configuration files
• Fix 6760: Within SSDT for Visual Studio 2015, the Expression Window can again edit package-level variables.
• Fix 6761: Within SSDT / BIDS, the Auditing Framework's connection name no longer changes when a different database is selected.
• Fix 6762: 'Video Help' link within BI xPress' package builder wizard now displays 'Product Help'
• Fix 6780: Control Flow Tasks and Data Flow Components that appear jumbled or stacked while using Auto Layout can now turn off Auto Layout.
• Fix 6817: Using the SSDT/BIDS Add-in/Extension and specifying a SQL Server 2016 database for use with the Auditing Framework no longer issues a warning
• Fix 7358: Within SSDT for Visual Studio 2015, applying / removing the notification framework throws error attempting to find SSISAlerts.DataFile.txt file
• Fix 7359: BI xPress' Auditing Framework applies the group name(s) to all groups instead of just the selected ones
• Fix 7366: Variable Usage Scanner ignores selected variables when attempting scanning
• Fix 7798: SSRS Database Connection dialog for Reporting Monitoring Console throws too many error messages when attempting to connect
• Fix 7815: Within SSDT for Visual Studio 2015, "License Not Found" error thrown when running Package Deployment
• Fix 6666: Licensing is now more robust and should not issue an error during installation.
• Fix 6009: SentryOne' Error Reporting is unable to send error
• Fix 6788: Upgrade older version of Workbench to latest does not install DOC xPress

Version 2016.3.7 [August 1, 2016]

New Features

• New 4064: Data Flow Tasks and their layouts are now automatically detected
  • New data flow tasks are now detected and shown in the Monitoring Console without having to re-apply the Auditing Framework. The layout for the data flows are auto-generated.

Fixes

• Fix 1921: Failed Data Flow Diagrams do not visually display the correct component that caused the failure
• Fix 4652: SSIS Containers Layout within Package Executions are not displayed well within Monitoring Console
• Fix 4724: Investigate why System.Exception error thrown when applying the auditing framework within Plugin to Task Factory DM SCD package
• Fix 4725: Enable querying of large ReportServer databases
• Fix 4885: Updated help video links within BI xPress.
• Fix 4989: Users can now use Auditing Framework when the same version of Task Factory is installed
• Fix 5461: Tables with multiple validation errors become unreadable as the errors are overlaid one on top of the other
• Fix 5535: BI xPress' Notification Engine now correctly accepts date and numeric data while receiving a Send Notification request.
• Fix 6054: Extract / Load Trend report throws "value cannot be null" error when loadings
• Fix 6055: Standard Runtime Deviation Report no longer issues a "XamlParseException" error
• Fix 6060: Package and Task Performance Report no longer issues a "NotImplementedException" error

Version 2016.2.4.504 [May 4, 2016]

New Features

• New 4386: SQL Server 2016 Support
• New 4592: BI xPress Extension for SSIS 2016.
• New 4293: SentryOne License Activator is now included.
• New 1478: Workbench now supports high DPI scaling on High Density displays as well as non-default DPI settings

Fixes

• Fix 4261: When filters are enabled at launch in High DPI Scaling, the non-filtered plugins won't scale accordingly
• Fix 3794: Importing SSIS Catalogs is now more efficient and faster.
• Fix 4075: Removing a Reporting Web Server from settings does not actually remove said server
• Fix 4120: Adding the Notification Engine to a package with "Use Package Parameters" set throws error
• Fix 4231: If the root object within the BPA Command Line tool violates a rule, '__unknown' is registered as ObjectName
• Fix 4465: Control Flow Containers within Monitoring Console aren't failing if one of components they contain fail
• Fix 3875: Logging wasn't working in some scenarios
• Fix 4261: When filters are enabled at launch in High DPI Scaling, the non-filtered plugins won't scale accordingly
• Fix 4932: The VSIX Uninstaller "Uninstall" button acts as a cancel button after initializing uninstallation

Version 2016.1.7.131 [January 31, 2016]

Updated Features

• Update Auditing Framework
  • (BIX-VSO-3424): Auditing Framework now better detects unsaved changes within an SSIS Project and asks the user to save changes before continuing
  • (BIX-VSO-1580): Dramatically increase the flexibility of the auditing framework when layout information becomes out of date
• Update Monitoring Console
  • (BIX-VSO-3349): When dynamically generating a data flow layout, Monitoring Console will infer as many of the component icons as possible
  • (BIX-VSO-3368): When new control flow tasks have been detected within SSIS Monitoring, the new task(s) will appear within the monitoring console
• Update Workbench
  • (BIX-VSO-3688): Chocolatey package ids have been changes to not include hyphens

Fixes

• Fix Config Editor
  • (BIX-VSO-3486): Config Editor now properly handles boolean properties saved within a configuration file
• Fix Notification
  • (BIX-VSO-3355): Update summary for the "Choose Notification Engine" page
• Fix SSIS Catalog Import
  • (BIX-VSO-3794): BI xPress no longer causes a MaxLength violation when importing executions containing large messages

Hotfix [February 24, 2016]

Fixes

• Fix BIDS / SSDT Add-In
  • (BIX-VSO-4472): The BI xPress BIDS / SSDT Add-in is now offering features the trial period.

v2015

Version 2015.3.7 [November 5, 2015]

New Features

• New Auditing Framework
  • (BIX-VSO-2228): The BI xPress Database is now version independent and only requires users to update if the currently used feature requires updating
  • (BIX-TFS-1498): SSIS Packages can now be organized using custom Package Groups
• New Monitoring Console
  • (BIX-TFS-1498): Package Executions can now be grouped and filtered using the Auditing Framework's Package Grouping Feature
• New Package Builder
  • (BIX-TFS-2236): Parameters can now be included in property names within the Package Builder
• New Workbench
  • (BIX-TFS-1854): LegiTest is now a part of the Workbench Installer

Updated Features

• Update Monitoring Console
  • (BIX-VSO-1254): BI xPress Monitoring Console now uses the same layout engine to display missing or outdate layouts and Data Flows no longer show a "layout out of date message"

Fixes

• Fix Auditing Framework
  • (BIX-VSO-2864): "Learn" button within Auditing Framework Add-in now points to the correct help documentation
  • (BIX-VSO-2712): Add validation to "Enable Large DB" window
• Fix Best Practice Analyzer
  • (BIX-VSO-2952): Fix stability issue when saving shard rule sets
  • (BIX-VSO-2591): Fix stability issue when unpinning the "Object Type Filters" panel while the object is still loading
  • (BIX-VSO-2279): Best Practice Analyzer now correctly analyzes SSIS Objects
• Fix Monitoring Console
  • (BIX-VSO-2829): Creating a scheduled purge with "daily" frequency now works as expected
  • (BIX-VSO-1314): Fixed typo within Package Execution context menu
• Fix Notification Framework
  • (BIX-VSO-2280) Fix issue when sending test e-mails during configuration
  • (BIX-VSO-1990) Notification Engine now shows up within SSIS 2012 Add-in
  • (BIX-VSO-1987) Entering an invalid BI xPress Server URL no longer disables Address textbox
• Fix Package Builder
  • (BIX-VSO-1762): Package Builder now properly saves changes to a template's description
• Fix SSIS Unit Testing
  • (BIX-VSO-2264): Parameter Commands now show correct value after being edited
  • (BIX-VSO-2263): Variable Commands now correctly update after being edited

Version 2015.2.6 [September 14, 2015]

Updated Features

• Update Workbench
  • Update installer to be compatible with Windows 10

Fixes

• Fix Auditing Framework
  • Fix error that occurs when creating the BI xPress Database on new machines

Version 2015.2 [September 3, 2015]

New Features

• New Notification Framework
  • Integrate the power of BI xPress Server into your SSIS Packages. Allowing you to send notifications to multiple groups or individual people via email, SMS, log files, SQL Scripts, or even Twitter. You can also build your own notification provider to suit your own needs.
• New Data Generation
  • Add ability to horizontally stripe data generators to produce segmented data
  • Add data generation seeds for producing predictable outputs to the data
  • Include support for composable generators
  • Include ability to insert static data within Data Generation solutions
  • Add Data Generation Command line tool

Updated Features

• Update Auditing Framework
  • (BIX-TFS-10417): Include ability to upgrade BI xPress Database to handle logging of a very large number of package execution details

Fixes

• Fix Auditing Framework
  • (BIX-TFS-10314): Fix error that occurs when closing out of Auditing Framework Add-in
• Fix Compile Script Tasks / Components
  • (BIX-TFS-11192): Fix "Conversion from string to type 'Boolean' is not valid" error while compiling scripts within BIDS / SSDT
• Fix Data Generation
  • (BIX-TFS-10535): Data Generation now correctly loads and upgrades Data Generation solutions created from previous versions
• Fix Package Builder
  • (BIX-TFS-10701 & 10702): Resolve issues when utilizing custom templates within Package Builder Wizard
  • (BIX-TFS-10715): Modify Package (From Template) now correctly adds the necessary connection managers to the package

v5

Version 5.8.5.505 [May 5, 2015]

Updated Features

• Update Auditing Framework
  • (BIX-TFS-9795): Update Auditing Framework to provide better support for third party components.
• Update BI xPress Add-in
  • (BIX-TFS-10505): Update BI xPress Add-in Feature Clash message to state BIDS / VS / SSDT instead of just BIDS.
• Update Monitoring Console
  • (BIX-TFS-9961 & 10129): Increase performance of the Extract Load Trend Report within the Monitoring Console Dashboard.
• Update SSIS Unit Test
  • (BIX-TFS-10001): Command type name now included at top of asserts to better differentiate them from one another.

Fixes

• Fix Auditing Framework
  • (BIX-TFS-9994): Applying Auditing Framework to SSIS Project within Pragmatic Workbench no longer throws a "projectFilepath" error.
  • (BIX-TFS-10314): Resolve "Object Reference Error" when closing out of the the Auditing Framework Add-in.
• Fix BI xPress Add-in
  • (BIX-TFS-10542): Remove error that occasionally occurs when saving profile upon shutdown of BIDS / VS / SSDT.
• Fix Best Practice Analyzer
  • (BIX-TFS-7816): Resolve stability issues with the Best Practice Analyzer when launching from within Visual Studio.
• Fix Data Generation
  • (BIX-TFS-8403): Resolve generation issue with TEXT, VARCHAR, and CHAR columns when specifying explicit values.
  • (BIX-TFS-10535): Provide means for Data Generation to upgrade previous versions of BI xPress Data Generation plans to the latest version.
• Fix Monitoring Console
  • (BIX-TFS-10042 & 10385): Resolve stability issues within package performance dashboard when clicking on graphs.
• Fix Notification Framework
  • (BIX-TFS-10170): Resolve issue with MSDB Folder browser not populating the Notification Framework with the selected path.
• Fix Package Builder
  • (BIX-TFS-10701, 10702, & 10715): Resolve issue with the creation and application of custom package templates to existing SSIS Packages.
• Fix SSIS Unit Test
  • (BIX-TFS-9574): Fix Parameter Command Setter and Getters to eliminate the "<NOT SPECIFIED>" error that is thrown.
  • (BIX-TFS-10000): "Run Select Unit Test" button now properly triggers unit test execution.
  • (BIX-TFS-10002): SSIS Unit Assert operations that return boolean values are no longer case sensitive.

Version 5.8.2.114 [January 14, 2015]

Updated Features

• Update Auditing Framework
  • (BIX-TFS-8771): Provided more details on package selection screen for different deployment models for the BIDS Add-on.
  • (BIX-TFS-2303): Update Package Selection screen to more accurately calculate the number of packages selected.
• Update General Usability
  • (BIX-TFS-9102): Update location for Expression Highlighter within Help Documentation more accessible.
  • (BIX-TFS-2868): Update BI xPress Help button within Add-in to correctly send users to the online help documentation.
• Update Reporting Dashboard
  • (BIX-TFS-783): Provide users with a friendlier notification when attempting to connect to a 2005 Reporting Server.

Fixes

• Fix Auditing Framework
  • (BIX-TFS-5696): Alert Filtering in SQL 2012 and 2014 are now properly being saved and applied.
  • (BIX-TFS-7405): Fix minor issues revolving the Auditing Framework "Create New BI xPress Database" button.
• Fix Best Practice Analyzer
  • (BIX-TFS-6096): The "Undo Changes" button will now only be enabled if there are unsaved changes present.
  • (BIX-TFS-7816): Resolved issue where Best Practice Analyzer Add-in becomes unresponsive when launched.
• Fix Monitoring Console
  • (BIX-TFS-8429): Resolved issue where components within SSIS Packages may display incorrect completion icon.
  • (BIX-TFS-9003): Include better row count validation within complex packages to prevent invalid row count values being presented within the Monitoring Console.
• Fix Reporting Dashboard
  • (BIX-TFS-8812): Resolved issue where Report Deployment would deploy all objects within Impact Analysis regardless of selection.
  • (BIX-TFS-8824): Resolved general stability issues within Report Deployment.
• Fix SSIS Unit Test
  • (BIX-TFS-8784): SSIS Unit Test now properly validates SQL 2014 ISPACs added to an SSIS Unit Test Suite.

Version 5.7.0.929 [September 29, 2014]

Updated Features

• Update Auditing Framework
  • (BIX-TFS-7287): Provide users the ability to select which packages they would like to remove the Auditing Framework from when using Project Deployment Mode
• Update Reporting Dashboard
  • (BIX-TFS-7644): Include ability to deploy reports to HTTPS Report Servers
  • (BIX-TFS-7467 - BIX-TFS-8434): Include filter options that allow users to select how many items they would like to retrieve and display

Fixes

• Fix Auditing Framework
  • (BIX-TFS-7764): Update database creation scripts to include required syntax when using default paths for database files
• Fix Best Practice Analyzer
  • (BIX-TFS-6532): "ScriptComponentInADataflow" and "CheckForRowCountInDataFlow" now returns the affected data flow name instead of "DataFlow"
  • (BIX-TFS-6607): Best Practice Analyzer now properly analyzes non-SSIS objects
  • (BIX-TFS-8585): Path builder now displays a friendly error message when loading objects
  • (BIX-TFS-7753): Resolve Workbench stability issues when exporting Best Practices Analysis Results to a file that is currently in use
  • (BIX-TFS-8584): Update SSRS Provider so that object properly loads
• Fix BI Compare
  • (BIX-TFS-7306): Errors occurring during comparison process now clarify what side of the comparison the error occurred on
• Fix Monitoring Console
  • (BIX-TFS-7285): Fix issue with Execute Package Task not being displayed correctly
  • (BIX-TFS-7515): Fix issue with attaching precedent constraints to the correct component when identically named objects are present
  • (BIX-TFS-7263): Resolves Workbench stability issues when using intermittent connections to the BI xPress Database
• Fix Snippet Wizard
  • (BIX-TFS-7758): Resolve issue using Placeholders in absolute paths while utilizing the Archive File snippet
• Fix SSIS Unit Test
  • (BIX-TFS-7294): Expected Results are no long cleared when a new command is selected
  • (BIX-TFS-6451): Expected results now flags tests as failed when internal SSIS error occurs
• Fix Workbench
  • (WKB-TFS-8676): Fix issue whereby the 'Group By' option within Preferences throws an Object Reference Error

Version 5.5.1.711 [July 11, 2014]

New Features

• New Auditing Framework
  • When applying the Auditing Framework, users will now be warned if any System::Propagate variable(s) are set to True.
• New Pragmatic Workbench
  • Include current key binding values to tooltips for plugin ribbon items.
  • Organize plug-in key bindings by product and alphabetically.
• New SQL 2014 Support
  • (BIX-TFS-5241 - BIX-TFS-5243): SQL Server 2014 support is here! All features of BI xPress have been updated with support for SSIS 2014 & SQL 2014 and is being released in BETA form. Please try this latest release out and let us know what you think. This release also supports the initial release of SSDT-BI 2014.

Updated Features

• Update Auditing Framework
  • (BIX-TFS-7291): Changed Create Database to include a "Default" location instead of showing a file path that may not exist on the local server.
• Update General Usability
  • (PWB-TFS-7341): Add more indepth logging to workbench features to aid troubleshooting
  • (PWB-TFS-7302): Organize plugin keybindings by Products and alphabetically
  • (BIX-TFS-7239): URL links within Workbench are handled intelligently onmachines where no web browsers are installed.
  • (PWB-TFS-7200): Add current keybindings to tooltips for ribbon items
  • (BIX-TFS-5603): Update Advisor now includes a preview window for displaying information regarding updates.
• Update Reporting Performance Monitor
  • (BIX-TFS-6781): Added time-out options for the SSRS Performance Monitor.

Fixes

• Fix Auditing Framework
  • (BIX-TFS-7297): Update Auditing Framework Add-in to no longer require a valid configuration file folder set regardless of whether or not using configuration files.
  • (BIX-TFS-7279 & 7014): Auditing Framework Add-in validates configuration file folder even when not using Configuration Files
  • (BIX-TFS-7028): Auditing Framework Add-in now searches projects using the project deployment model for existing project connection managers for use.
  • (BIX-TFS-6609 & 7178): Database path now automatically updates to a server's default path when changing Servers to create database.
• Fix Best Practice Analyzer
  • (BIX-TFS-7552): Update Best Practice Analyzer to no longer require a Filter to be set on an SSIS item to allow analyzing of Best Practice rules.
  • (BIX-TFS-6294): When you "Save As" within User Defined Best Practices, it now shows the original and new Best Practice within the list.
• Fix BI Compare
  • (BIX-TFS-7306): Add improved error handling to BI Compare to help clarify what side of the comparison the error occurred on.
• Fix Monitoring Console
  • (BIX-TFS-7335): Update Monitoring Dashboard to allow the printing and exporting of reports to PDF and DOCX formats.
  • (BIX-TFS-7029): Monitoring Console now properly display Execute Package Tasks as failing when child package fails.
• Fix SSIS Unit Test
  • (BIX-TFS-7172): Adding a new command clears the Expected Results in SSIS Unit Testing Assert.

Version 5.1.1.411 [April 11, 2014]

Updated Features

• Update General Usability
  • (BIX-TFS-6238): Provide more details to BI xPress Database schema update messages.
• Update SSIS Unit Test
  • (BIX-TFS-6763): SSIS Unit Tests do not execute sequentially when referencing a package within the same compiled project.

Fixes

• Fix Auditing Framework
  • (BIX-TFS-5534): Custom Variable Logging applied within Workbench now correctly logs the variable's value(s).
  • (BIX-TFS-6985): Auditing Framework now limits users from applying the Auditing Framework to both SSIS 2005 and SSIS 2012 packages in the same "batch".
• Fix Best Practice Analyzer
  • (BIX-TFS-6291): Fix issue where User Defined Best Practices will trim spaces from text boxes while users are still editing.
  • (BIX-TFS-6313): Best Practices should now no longer duplicate User Defined Best Practices within the list of rules.
  • (BIX-TFS-6317): Non-SSIS Objects that are evaluated should now properly be saved.
  • (BIX-TFS-6316): Best Practices should no longer display "Evaluating selected packages..." when evaluating objects that are not SSIS Packages.
  • (BIX-TFS-6336): Command Prompt tool now evaluating all rules properly.
• Fix Data Generation
  • (BIX-TFS-6415): Data Generation now properly handles Decimal, Money, Numeric, CHAR, and NCHAR values.
  • (BIX-TFS-6423): Update list of unsupported Datatypes within Data Generation.
• Fix Monitoring Console
  • (BIX-TFS-6707): Fix visual status of tasks within containers to show their correct status when the package is still executing.
• Fix Notification Framework
  • (BIX-TFS-5745): Notification Framework will now export log file if user selects only to use Log File logging.
• Fix SSIS Catalog Import
  • (BIX-TFS-6678): Clicking "BI xPress Database" button now launches the "Connect to Database" window.
• Fix SSIS Unit Test
  • (BIX-TFS-5410): Packages will now execute within the correct (Project or Package) Deployment Model.
• Fix Workbench
  • (BIX-TFS-6349): Toolbar Ribbon will no longer disappear for the remainder of the session if a user double-clicks on a tab and then closes out of the tab.
  • (BIX-TFS-6647): Update Feature Finder Technology Filter to include Best Practice Analyzer under SSAS, SQL, and SSRS.

Version 5.0.20.121 [January 21, 2014]

New Features

• New Data Generation
  • (BIX-TFS-4476 & BIX-TFS-5337): Data Generation is the latest feature in BI xPress that creates random data or joins disparate data into database table(s) for use in testing and profiling your BI environment. Test Data Generation uses solution files so your settings can be saved and shared amongst your team.
• New Best Practices
  • (BIX-TFS-3902): Allow user to export BPA results within the UI to CSV or HTML.
  • (BIX-TFS-6248): SSIS Naming Convention Best Practices, SQL Best Practices, SSAS Best Practices, and SSRS Best Practices.
• New Workbench
  • (WKB-TFS-6145): Enable installing multiple versions of Workbench (including BI xPress, DBA xPress, and DOC xPress) on the same computer.
  • (WKB-TFS-6233): Create X86 / 32-Bit solution for Workench and include it in the installer, only install on 64-bit OS.

Updated Features

• Update Best Practice Analyzer
  • (BIX-TFS-6262): Allow users that have a trial license of Best Practice Analyzer the ability to test the Best Practice Command Line tool.
• Update Monitoring Console
  • (BIX-TFS-3666, 3667 & 5613): Update Monitoring Console to allow users the ability to view initial value of variables at the time of adding the Auditing Framework.
• Update SSIS Unit Test
  • (BIX-TFS-5909): Include Move Up / Move Down functionality within context menu of SSIS Unit Test.
  • (BIX-TFS-5910): SQL Command now defaults to "Return Result&qupt; set to True.
  • (BIX-TFS-5257): Provide a way to create connection strings for common ADO.NET provider types.
• Update Workbench
  • (BIX-TFS-9795): Use adorners to show Beta / Not Licensed status.
    (BIX-TFS-5557): Update installer to be compatible with Windows 8.1.

Fixes

• Fix Auditing Framework
  • (BIX-TFS-2635): Auditing Framework now support applying to packages that are deployed with "Server Storage" protection mode.
  • (BIX-TFS-4988): Auditing Framework now validates / creates configuration folder if one does not exist.
  • (BIX-TFS-5206): Resolve stability issues within SSDT when applying the Auditing Framework to packages from the file system.
  • (BIX-TFS-5685): Resolve Auditing Framework application issues when applying the Auditing Framework to SSIS 2012 packages with row counts enabled.
  • (BIX-TFS-5534): Include validation to Custom Variable logging within Workbench.
• Fix Best Practice Analyzer
  • (BIX-TFS-5662): Best Practice Analyzer now prompts user for passwords for SSIS Packages instead of skipping said packages.
  • (BIX-TFS-6262): User Defined Best Practices feature now enabled for Trial versions of BI xPress.
  • (BIX-TFS-6312): Resolve stability issues within User Defined Best Practices feature when attempting to save to a file flagged as read-only.
  • (BIX-TFS-6334): Update Best Practice Command Line to clarify that it only supports SSIS.
• Fix BI xPress Add-in
  • (BIX-TFS-5582): BI xPress Add-in now allows users to choose which edition users can trial when using a Trial License of BI xPress.
  • (BIX-TFS-5609): BI xPress Add-in now correctly displays the current version of BI xPress.
  • Fix Monitoring Console
  • (BIX-TFS-3905): Switching between variable views no longer resets filters that were applied.
  • (BIX-TFS-5156): Users are now allowed to purge the entire BI xPress database by entering "0&qupt; for the number of days to keep.
  • (BIX-TFS-5192): Timers on control flow components now updates based on user set "Refresh Rate" within the options window.
  • (BIX-TFS-5386): Update Filter by Package name feature within Options to properly filter.
  • (BIX-TFS-5461): Resolve stability issues within Execute \ Load Trend report.
  • (BIX-TFS-5461): Resolve stability issues within the Extract \ Load Detail report.
  • (BIX-TFS-6061): Resolve stability issues within the Recent Execution Detail report.
  • (BIX-TFS-6225): Recent Executions now correctly displaying Start and End Time.
  • (BIX-TFS-6257): Include support for most Unicode characters within names and values of SSIS Tasks, Components, and Connection Managers.
• Fix SSIS Catalog Import
  • (BIX-TFS-4260): Most recent catalog executions are now ordered correctly.
  • (BIX-TFS-5873): Package execution start times are now correctly displayed after importing.
  • (BIX-TFS-5873): Package executions that have previously been imported will no longer be re-imported.
  • Fix SSIS Unit Test
  • (BIX-TFS-5849): Users no longer need to include a Data Compare Assert to the last unit test within a test suite.
  • (BIX-TFS-5861): Users can now edit package paths without having to remove and re-add the package references.
• Fix SSRS Report Dashboard
  • (BIX-TFS-5469): Allow users to deploy report objects to the root directory of a report server.
• Fix Workbench
  • (BIX-TFS-5106): Update behavior between Workbench and alert and confirmation windows if focus is lost.
  • (BIX-TFS-6144): Installation directory is now removed when uninstalling Pragmatic Workbench.

v4

Version 4.9.33.1021 [October 21, 2013]

New Features

• New SSIS Unit Test
  • (BIX-TFS-4475): Dataset testing allows comparison of two datasets against each other. A dataset can be a live dataset that gets its data from a data source or it can be cached within the test suite. Typically a test will contain a cached dataset which will act as the "expected" dataset and also contain a live dataset which will be populated from a data source after a package or task has executed. The two datasets are compared using the new DataCompareCommand and is easy to setup with just two options, Expected and Actual datasets.
  • (BIX-TFS-5025 & BIX-TFS-4841): SSIS Unit Test now supports SSIS 2012 projects via *.ispac files and the SSIS Catalog as well as project and package parameters. Users can now select a package within a *.ispac file or SSIS Catalog, specify parameters, execute the package and task, and test for expected values and outcomes using the new Property Command.
  • (BIX-TFS-4888 & BIX-TFS-5025): [BI xPress PRO Feature] Executing SSIS Unit Tests during automated processes is now possible by using the new 32-bit or 32-bit/64-bit standalone applications. These two applications are identical except the X86 executable will only execute the test suite and package or task in 32-bit mode.
  • (BIX-TFS-4601): Add ability to give name to package reference at test suite level.
  • (BIX-TFS-4785): Allow exporting of SSIS Unit Testing results, datasets, and data comparisons.
  • (BIX-TFS-4796): SSIS Package Store and SQL Server (MSDB) package locations can now be accessed in SSIS Unit Test.
  • (BIX-TFS-4930): Users can now specify passwords for packages and SSIS 2012 Project Deployment Model projects. Note:  The passwords are not encrypted when saved to the *.ssisunit Test Suite file. Be sure to save the packages in a secure location.
• New User Defined Best Practices
  • (BIX-TFS-3386 & BIX-TFS-4235): [BI xPress PRO Feature] User defined best practices are rules created by users to find violations of best practices. Each best practice can target violations such as naming conventions, property settings, variable values, and much more. A user defined best practice file can be shared among team members and evaluated along with BI xPress' built-in best practices.

Updated Features

• Update (BIX-TFS-4107): Monitoring Console timeout issue. There is now a configurable timeout option in the Monitoring Console for users with large BI xPress databases or slow connections.
• Update (BIX-TFS-5024): Enabled some project / folder selection in some features of BI Compare.
• Update (BIX-TFS-4736): Optimized Visual Studio startup time.

Fixes

• Fix (BIX-TFS-2427): If application errors while importing executions from SSISDB, must notify end-user of status.
• Fix (BIX-TFS-2456): Auditing Framework: Timeout for fetching existing connection managers too long.
• Fix (BIX-TFS-2695): Package Deployment folder structure is created incorrectly.
• Fix (BIX-TFS-2724): Monitoring Console: Package Executions List column re-sizer unexpected behavior.
• Fix (BIX-TFS-3234): User changes database while inside dashboards, does not change connection.
• Fix (BIX-TFS-3244): Calc Builder displays incorrect name for Percentage of Parent template.
• Fix (BIX-TFS-3245): Calculation builder inside Visual Studio 2010 still shows 2008 version in title bar.
• Fix (BIX-TFS-3247): Expression List displays expressions based on "Evaluate As Expression" being set to true, but if expression is NULL, BIxPress throws obj ref error.
• Fix (BIX-TFS-3252): Cannot navigate back within MDX Calculation builder.
• Fix (BIX-TFS-3445): Parsing multi-line variable expression is recorded as multiple variable values.
• Fix (BIX-TFS-3637): Package with password/save sensative security receives error in BIDS Add-In.
• Fix (BIX-TFS-3784): Package Parameters cause errors on PreExecute and PostExecute if they don't exist in current scope.
• Fix (BIX-TFS-3994): System.Threading error when initializing SSDT 2010 for the 1st time after installation. The "What's New" page will now wait at least 3 seconds before loading.
• Fix (BIX-TFS-4124): Notification Framework on packages with checkpoints fail. Rewrote the Notification Framework to not use Object variables and instead uses a new string variable to store messages.
• Fix (BIX-TFS-4223): Visual Studio 2012 add-in registry errors. VS2012's new behavior doesn't replicate registry keys as previous versions did.
• Fix (BIX-TFS-4271): Notification Framework: 2005 Email notification throws expression expected error.
• Fix (BIX-TFS-4551): During Modify Packages (From Selection), control flow components are deleted when user cancels the Package Builder Wizard. This only occurred on packages that weren't saved prior to opening the Package Builder Wizard. The issue has been fixed.
• Fix (BIX-TFS-4583): Variable Commands do not display a check\X when they pass\fail.
• Fix (BIX-TFS-4584): Unit Tests that are set to run tasks based on GUID instead of name fail to display "Pass/Fail" when executed.
• Fix (BIX-TFS-4602): Display value of the unit test case's package reference.
• Fix (BIX-TFS-4705): Editing Expressions within SSDT for Visual Studio 2012 on packages included within a *.CSPROJ/*.VBPROJ causes VS2012 Crash.
• Fix (BIX-TFS-4707): Auditing Framework checks for existence of config folder regardless of necessity.
• Fix (BIX-TFS-4709): If user removes package reference without removing associated connection, will throw object reference error, crash workbench.
• Fix (BIX-TFS-4713): GUI should not allow user to add assertion without a name.
• Fix (BIX-TFS-4800): Remove the "Copy" option from Directory Commands as that isn't a valid option.
• Fix (BIX-TFS-4801): Variable Command throws "Item w/ same key" error.
• Fix (BIX-TFS-4812): Changing from an invalid package reference to a valid one crashes workbench.
• Fix (BIX-TFS-4864): Fix SSIS 2012 Error Output mapping on Auditing Framework.
• Fix (BIX-TFS-4955): Project parameters / Configuration entries are being added to AF from workbench even if none are selected. The resolution caused a slight redesign of the UI to make the options clearer.
• Fix (BIX-TFS-4979): Handle DTSRuntimeWrap DLL loading issues on machines that don't have full SSIS 2012 runtime installed in SISS Unit Testing.
• Fix (BIX-TFS-4998): Commands do not time out if no package is specified in Unit test.
• Fix (BIX-TFS-5098): Adding a new assert without all of the fields populated causes the assert to not be added to the unit test.
• Fix (BIX-TFS-5146): Timing issue while selecting packages from a project in SQL 2012. Sometimes the children will not load but if the user closes and opens then the children do load.
• Fix (BIX-TFS-5386): Filtering within Monitoring Console was throwing an error.
• Fix (BIX-TFS-5404): Item with the same key in SSIS Catalog Import.

Version 4.7.30.729 [July 30, 2013]

New Features

• New SSIS Unit Test
• (BIX-TFS-3382): Unit testing allows developers, users, and package life-cycle administrators to ensure that a package is performing exactly what the developer implemented and handling unexpected circumstances with predefined behavior. Unit testing allows specified inputs to be used as "source" data and evaluates the task output with expected task output thereby ensuring the package behaves correctly.
• New Monitoring Console
• (BIX-TFS-2511): Add the ability to right-click on a package execution and mark as "stopped" within the SSIS Monitoring Console.
• (BIX-TFS-2777): Create feature to clear execution history from records using SQL Agent job.
• (BIX-TFS-3782): Create drop down inside each container or task within the control flow that shows each iteration's execution details and how many times that task executed.
• New Visual Studio Integration
• (BIX-TFS-3294): Visual Studio Integration 2012 SQL Server Data Tools Support
• (BIX-TFS-3822): Make Pragmatic Workbench accessible from BIDS / SSDT.
• (BIX-TFS-3824): After upgrading Pragmatic Workbench, show the "What's New" release notes inside BIDS / SSDT.
• New Workbench
• (WKB-TFS-3703): Create new UI Grouping for Workbench Features.

Updated Features

• Update (BIX-TFS-3025): Add support for password protected packages to the Best Practices feature (within UI and Console).
• Update (BIX-TFS-3676): Save required fields to user profile for the BI xPress Purge feature.

Fixes

• Fix (BIX-TFS-1863): '<', hexadecimal value 0x3C, is an invalid attribute character. Line 1, position 54.
• Fix (BIX-TFS-2223): New Template from package.
• Fix (BIX-TFS-2241): 2012 Configuration Wizard: Operation or method is not implimented.
• Fix (BIX-TFS-2299): If BIxPress folder doesn't exist in documents, create it.
• Fix (BIX-TFS-2303): Refresh button does not remove packages from list.
• Fix (BIX-TFS-2549): Upgrading database in Windows XP fails, freezes.
• Fix (BIX-TFS-2708 & BIX-TFS-4269): Foreign number settings (locale settings) can affect the input string for Auditing Framework.
• Fix (BIX-TFS-3015): Load and Save drop down menus should close after selection.
• Fix (BIX-TFS-3025): Analyze packages with password protection by creating a window or field to enter password if exists.
• Fix (BIX-TFS-3061): Allow users to specify the BI xPress database log file location when creating the BI xPress database.
• Fix (BIX-TFS-3065): Connection user selects in "Browse for Existing" does not carry to connection manager.
• Fix (BIX-TFS-3072 & BIX-TFS-3697): SSIS 2012: If user selects VB for script language, Framework is applied in C#..
• Fix (BIX-TFS-3093): Recent Executions Detail dashboard fails if user excludes variable and/or connection logging.
• Fix (BIX-TFS-3194): Create meaningful error message if user attempts to analyze files that are not SSIS packages.
• Fix (BIX-TFS-3233): "Item w/ same key has already been added" when viewing Recent Executions Detail dashboard.
• Fix (BIX-TFS-3246): Cannot apply AF to package, receives "An error occurred while parsing EntityName. Line 1, position 110."
• Fix (BIX-TFS-3262): Best Practices within SSDT does not load data into BIxPress repository or display in error log.
• Fix (BIX-TFS-3281): If Solution has multiple projects, package selector will only open one.
• Fix (BIX-TFS-3285): If user does not change the default config folder, it will throw error when attempting to apply framework.
• Fix (BIX-TFS-3295): "Insert Nugget" option not enabled when the Source of a Precedent Constraint is a Data Conversion Transform or Lookup Transform.
• Fix (BIX-TFS-3369): Config files are being deployed to the location specified in the source, not the target.
• Fix (BIX-TFS-3520): Config Highlighter for variable not working.
• Fix (BIX-TFS-3521): "Internal Error/Object reference" when attempting to view a report that was deployed using SSRS Report Deployment plug-in.
• Fix (BIX-TFS-3542): When attempting to deploy Linked Report, user receives unhandled exception.
• Fix (BIX-TFS-3595): Invalid Collation (Latin_General_100_BIN) should be Latin_General_BIN.
• Fix (BIX-TFS-3623): Enable "Insert Nugget" feature for Asynchronous Outputs.
• Fix (BIX-TFS-3627): Use SQL 2005 schema instead of 2008.
• Fix (BIX-TFS-3668): After the first run of the Loop all the components in the Foreach loop remain "Completed/green".
• Fix (BIX-TFS-3684): "See What's New" button does not direct user.
• Fix (BIX-TFS-3688): Attempting to save Shared Ruleset to database crashes Workbench.
• Fix (BIX-TFS-3742): Package Performance dashboard: DateDiff function resulted in an overflow.
• Fix (BIX-TFS-3784): Package Parameters cause errors on PreExecute and PostExecute if they don't exist in current scope.
• Fix (BIX-TFS-3903): Ensure that the Dashboards do not throw errors when attempting to view them.
• Fix (BIX-TFS-3939): SSRS Unknown error while connecting to server.
• Fix (BIX-TFS-4120): BI Compare "Finish" button that launches comparison should be disabled until both sides are set.
• Fix (BIX-TFS-4128): Value of Row Count does not fall within the expected range.
• Fix (BIX-TFS-4130): After extended idle, came back to ObjectDisposedException, crashed Workbench.
• Fix (BIX-TFS-4135): "Unable to case COM object of type 'System._ComObject' to interface type" when applying Auditing Framework.
• Fix (BIX-TFS-4223): Ensure installing user's Visual Studio 2012 registry is updated to include the BI xPress Addin location. All other users may have to execute VS2012's /setup flag (more information).
• Fix (BIX-TFS-4245): InvalidOperationException while toggling between control flow and data flow - Crashes Workbench.
• Fix (BIX-TFS-4263): Investigate why "Skip If Different" option causes failure.
• Fix (BIX-TFS-4271): Notification Framework: 2005 Email notification throws expression expected error.
• Fix (BIX-TFS-4272): SSIS Unit Test: User adds invalid package, save throws System.Exception.
• Fix (BIX-TFS-4292): Update dialog for Directory Command.
• Fix (BIX-TFS-4484): Some SSIS Projects/Solutions do not expand to show packages contained within.
• Fix (BIX-TFS-4489): Loading Visual Studio 2012 (full, not BIDS Shell) after installing update KB2781514 causes "Cannot get the SSIS Designer menu bar".
• Fix (BIX-TFS-4736): Greatly improved Visual Studio 2005/2008/2010/2012 (a.k.a BIDS or SSDT) loading time when BI xPress add-in is installed.
• Fix (BIX-TFS-4732): Browsing SSIS 2012 Catalog in BI Compare and within DOC xPress now creates the correct dialog.

Service Release [July 16, 2013]

Fixes

• Fix (BIX-TFS-4624): Create schedule for Purge BI xPress Database throws exception.
• Fix (BIX-TFS-4643): SentryOne' code signing certificate has been updated.
• Fix (BIX-TFS-4650): Collation difference is causing Pragmatic Workbench to crash in SSIS Monitoring Console (only prevents crash, user must currently address collation issues).
• Fix (BIX-TFS-4651): Very rare bug: When using the SSIS Monitoring Console Options, if the timing is just right Workbench will crash due to null reference exception.

Service Release [July 10, 2013]

Fixes

• Fix (BIX-TFS-4907): Some shared components required for operation within BI xPress weren't being installed when the user chose not to install DOC xPress.

Version 4.5.23.411 [April 19, 2013]

New Features

• New Best Practices Analyzer
  • (BIX-TFS-3128): The new Best Practices Analyzer enables users to see how well their packages adhere to best practices. There are currently twelve best practices that you can use to make sure your package is running efficiently and implements your organization's policies.
• New Monitoring Console
  • (BIX-TFS-3042): New filtering within the SSIS Monitoring Console now allows filtering by package name as well as different execution views. The different options for loading package executions are most recent N-number of executions, the executions within the last N-number of hours / days / weeks / months / years, or executions between two specified dates.
  • (BIX-TFS-3443): The SSIS Monitoring Console now includes a variable history view. This will list all of the variables value changes that were recorded by the Auditing Framework in chronological order.
  • (BIX-TFS-3465): The SSIS Monitoring Console now includes the ability to view errors, warnings, or both.
• New SSRS Report Deployment
  • (BIX-TFS-3042): An updated SSRS Report Deployment feature now includes the ability to detect which data sources a report depends on and optionally deploy them as well. This update will also test to see if deploying a report will impact other reports and data sources at the destination allowing you to take informed action as whether or not to deploy the report and data sources.
• New Deployment Wizard
  • (BIX-TFS-964): Package deployment for SSIS 2012 packages is now supported using the Deployment Wizard. NOTE: The project deployment model is NOT supported, please use SSDT's project deployment features.

Updated Features

• Update (BIX-TFS-3364): Informational icons have been added to the Recent Executions Summary and Recent Executions Details dashboards.

Fixes

• Fix (BIX-TFS-734): Re-create proper XML Layout when applying Auditing Framework to SSIS Package.
• Fix (BIX-TFS-1693): Performance History reports have differing results.
• Fix (BIX-TFS-1874): STD Dev dashboard fails if executions qualify.
• Fix (BIX-TFS-1906): Y-Axis scale is lost if user is looking at executions farther than the very left of chart.
• Fix (BIX-TFS-1912): BI Compare drop down for source type does not have any values.
• Fix (BIX-TFS-1974): User deselects all packages, "Must select at least one package" message displays.
• Fix (BIX-TFS-1976): User selects "Use Existing Configurations" crashes Workbench.
• Fix (BIX-TFS-1977): Opening a new feature (monitoring console, deployment, etc) opens behind workbench window.
• Fix (BIX-TFS-1980): Auditing framework not finding packages through SQL Server connection.
• Fix (BIX-TFS-2197): Allow users to specify the BI xPress database log file location when creating the BI xPress database.
• Fix (BIX-TFS-2288): Case sensitive collations are now re-supported for the BI xPress database.
• Fix (BIX-TFS-2306): Auditing Framework adds extension to connection name, causes connection failure for SSIS 2012 Project Deployment projects.
• Fix (BIX-TFS-2318): Workflow diagram with Sqnce containers or ForEach Loop unorganized.
• Fix (BIX-TFS-2687): Fix issue where duplicate SSIS Catalog Executions are being inserted and erroring out in the SSIS Catalog Import feature.
• Fix (BIX-TFS-2753): Workbench crashes when attempting to add auditing framework to package using Package Store connection.
• Fix (BIX-TFS-2759): Recent Execution Detail Report's Filter Option does not filter.
• Fix (BIX-TFS-2760): Recent Execution Detail crashes Workbench when filters are enabled and the user attempts to sort a columns..
• Fix (BIX-TFS-2763): Clicking on a package execution within Recent Executions Detail while the Monitoring Console was open crashed Workbench.
• Fix (BIX-TFS-2856): Add new stored procedure for purging BI xPress database records in batches.
• Fix (BIX-TFS-2999): Monitoring console missing precedence constraints for SQL 2012.
• Fix (BIX-TFS-3007): Allow user to use existing connections in the Workbench Auditing Framework.
• Fix (BIX-TFS-3072): If user selects VB for script language, Framework is applied in C#.
• Fix (BIX-TFS-3074): Invalid Server when creating new BI xPress database crashes workbench.
• Fix (BIX-TFS-3093): Recent Executions Detail dashboard fails if user excludes variable and/or connection logging.
• Fix (BIX-TFS-3142): "refreshes every [#] sec" text box does not update when changed.
• Fix (BIX-TFS-3241): Add support for SSIS property expressions within Carbon Framework. Useful for BI Compare and Best Practices Analyzer.
• Fix (BIX-TFS-3248): SSIS Monitoring Console throws "Value cannot be null", crashes Workbench with specific package.
• Fix (BIX-TFS-3264): Investigate why the SSIS Multiple Hash open source component fails when applying the Auditing Framework.
  • After doing some research into why the Multiple Hash component's custom properties get cleared when applying the Auditing Framework, it appears that the component wasn't written to take into account that the package may be altered programmatically and expects the user to manually update the component when it's input has been detached.
  • Looking at this component's source code on CodePlex, the OnInputPathDetached(int inputID) method within the MultipleHash.cs file clearly removes all output columns (and their custom properties) generated by this component. This component is implemented as a Synchronous component. 
  • This issue can be re-created without the use of BI xPress by simply having a source connected to a Multiple Hash connected to a destination. A user then "sets up" the Multiple Hash properties and adjusts its outputs to feed into the destination inputs. The user can then execute the package and see that the column(s) specified do indeed get hashed and fed to the destination. Next, the user then simply deletes the data flow path from the source to the multiple hash, and boom! all of the properties set in the Multiple Hash component have been deleted. 
  • When applying the Auditing Framework, we temporarily remove the input path, insert a row count, and then hook it back up to it's original destination. When we remove the input, all user-specified properties get removed due to the way the component was written.
• Fix (BIX-TFS-3268): While applying the Auditing Framework to multiple packages, if there was an error the entire process stopped and subsequent packages weren't processed.
• Fix (BIX-TFS-3507): Best Practices Analyzer is throwing an unhandled exception on some Windows 8 computers but not Windows 7.
• Fix (BIX-TFS-3517): '.', hexadecimal value 0x00, is an invalid character error when attempting to view packages in the SSIS Monitoring Console.
• Fix (BIX-TFS-3521): "Internal Error/Object reference" when attempting to view a report that was deployed using SSRS Report Deployment plugin.
• Fix (BIX-TFS-3524): "Conversion failed when converting from a character string to uniqueidentifier" error occurred in the Monitoring Console and Recent Execution Summary and Detail dashboards.

Service Release [April 3, 2013]

Fixes

• Fix (BIX-TFS-3467): Add Auto-completion to the SSIS Monitoring Console filtering control.

Version 4.1.70.128 [January 28, 2013]

New Features

• New Pragmatic Workbench
  • (PWB-TFS-2502): Enables a set of pre-made themes to customize the colour scheme of your Workbench home screen as well as enabling you to choose your own by creating an XML file in the C:\Users\[user name]\AppData\Roaming\PragmaticWorks\Core\Themes folder. Feel free to use an existing theme as a template and share with your friends and co-workers.
  • (PWB-TFS-2010): Organizes the list of Features by the product they belong to on the preferences pane.
  • (PWB-TFS-2320): Enhanced security and removes the need to uninstall and re-install the product. Also enables organizations to share one product key with a limited number of activations.
  • (PWB-TFS-2522): Enables users to simply type the first few letters of the feature they need, and the list of Workbench features is filtered accordingly.
  • (PWB-TFS-1886): When entering in the server name for your connection, Pragmatic Workbench will now save the recently used servers. This will allow for easy selection in the future by including it in the drop down list.
• New SSIS Catalog Import
  • (BIX-TFS-2173): BI xPress's latest feature enables users to import SSIS 2012 Catalog data into a BI xPress database. Simply importing data versus instrumenting a package with event handlers, custom code, and variables allows users to execute their packages without modifying the contents of their packages while still being able to use BI xPress' SSIS Monitoring Console.
• New Monitoring Console
  • (BIX-TFS-2414): The Monitoring Console that you know and love is now an integrated part of the Pragmatic Workbench. The SSIS Monitoring Console has been completely redesigned and features smoother and faster rendering, tear-out windows and tabbed views (just like BIDS / SSDT), and accurate package rendering based on the layout details provided by BIDS / SSDT.

Updated Features

• Update (BIX-1715): Standard Deviation dashboard has been redesigned to only show packages that have abnormal runtimes. Also, only the latest package execution is considered for a runtime deviation outside the normal runtime for the package. The parameters are configurable to consider more than one package execution as well as the thresholds of standard deviation to consider "abnormal".

Fixes

• Fix (BIX-TFS-431): Notification Framework SQL 2008 Package Referenced Variable User::varSSISOps_FilteredVars cannot be found
• Fix (BIX-TFS-1423): Package parameter in Notification framework will not execute.
• Fix (BIX-TFS-1424): A reference to MSDDSP.dll wasn't being correctly referenced in SSIS 2005 only machines.
• Fix (BIX-TFS-1609): Out of memory exception for BIxPress running Monitoring Console reports
• Fix (BIX-TFS-1645): Generate formatted HTML from query fails if boolean set to true.
• Fix (BIX-TFS-1955): Report Deployment destination format error while attempting to move SSRS reports from one server to another.
• Fix (BIX-TFS-2171): BIxPress doesn't recognize DataFlowExecutionLog table missing
• Fix (BIX-TFS-2236): BI Compare Usability Features
• Fix (BIX-TFS-2263): Objects with no designated name cause Object Border to not completely cover the Object Title
• Fix (BIX-TFS-2273): "Object Reference Error" when using Custom Package Level Variable Logging
• Fix (BIX-TFS-2300): Apply auditing framework takes invalid connection.
• Fix (BIX-TFS-2302): The Auditing Framework OnPreExecute contains a ForLoop instead of a Script Task
• Fix (BIX-TFS-2337): Report Deployment fails "System.ServiceModel.Channels.ServiceChannel"
• Fix (BIX-TFS-2422): Notification Framework does not execute if the user chooses not to notify via e-mail.
• Fix (BIX-TFS-2602): Modify Auditing Framework to use only version specific SQL Server Log Providers
• Fix (BIX-TFS-2631): Variable Dependency Scanner was issuing an exception when encountering Script Components in a Data Flow.
• Fix (BIX-TFS-2637): Re-engineered some statements for SQL 2005 compatibility.
• Fix (BIX-TFS-2639): BI xPress case sensitivity was causing the SSIS Monitoring Console to not display execution data correctly.
• Fix (BIX-TFS-2642): SMS Text header was always regardless of the actual execution status of the package.
• Fix (BIX-TFS-2654): The Snippet Manager and default snippets now by default point to the "My Documents\BI xPress" folder instead of the application directory. The default snippets also get copied to the application directory for backup purposes.
• Fix (BIX-TFS-2669): Added support for packages that have a package protection level of Encrypt All with Password while selecting packages within the Pragmatic Workbench application.

Version 4.0.0.103 [October 3, 2012]

New Features

• New Pragmatic Workbench
  • (BIX-TFS-1639):Pragmatic Workbench is now the home to BI xPress. Each of BI xPress' features can be accessed from the Features view.
• New Insert Data Flow Nugget
  • (BIX-TFS-1292): BI xPress' Insert Data Flow Nugget allows you to insert reusable "nuggets" into your existing data flows. Users can create a Data Flow Nugget package that contains numerous data flows which can then be shared and reused inside other data flows. A Data Flow Nugget must begin with a Task Factory Placeholder Source component and ends with a Task Factory Terminator Destination. The Data Flow Nugget can contain any number of components between the Placeholder Source and Terminator Destination which may be some form of business rules implementation, auditing, reporting, and much more.

Fixes

• Fix (BIX-TFS-1914): Object Reference Error when applying the Auditing Framework to SSIS 2012 packages in certain scenarios.
• Fix (BIX-TFS-1704): Added additional logging for the BIDS / SSDT add-ins. This will help in diagnosing issues with crashing and unexpected errors. The log files appear in: ..\\BI xPress\AppLog_BIxPressAddin_20XX.txt.
• Fix (BIX-TFS-1501): Rename HTML Notification template from "Startdard" to "Standard".
• Fix (BIX-TFS-1502): Update SMS Text Messages to avoid emoticons on modern phones for Notification Framework.
• Fix (BIX-TFS-1643): Package Execution Trend report (Specified cast is invalid).
• Fix (BIX-TFS-1642): Specified cast not valid error in Performance History (Package) report.
• Fix (BIX-TFS-1543): Monitoring Console wasn't behaving correctly when no versions or incorrect versions of SSIS were installed.
• Fix (BIX-TFS-1433): Quick Deployment feature would timeout if the user didn't have a default instance on the local machine.
• Fix (BIX-TFS-1440): When closing BIDS / SSDT, there were some events unnecessarily processed causing BIDS / SSDT to close more slowly.
• Fix (BIX-TFS-449): The dynamic path preview didn't always update correctly in the Configuration Manager.

v3

Version 3.5.5.77 [July 7, 2012]

New Features

• New Visual Studio Integration
  • (BIX-TFS-1110): BI xPress' Quick View enables viewing the entire execution status message from within the BIDS / SQL Data Tools environment. Save time by using the Quick View feature which allows you to view the entire message, copy all or parts of the message to your clipboard, and then to an internet browser or document.
  • (BIX-TFS-1111): BI xPress' Reset IDs feature will allow you to generate new IDs for SSIS packages. When users copy and paste SSIS packages, the IDs are not regenerated which can cause issues later. The Reset IDs feature will reset all GUID IDs within the selected packages. Also, for those packages that have the Auditing Framework installed, it will detect and prompt you to re-apply the Auditing Framework with the newly generated IDs. If the Auditing Framework is not installed on a selected package, no further action is needed.

Version 3.5.3.625 [June 25, 2012]

New Features

• New SSIS 2012 Support
  • (BIX-TFS-740): BI xPress now includes the ability to store the configuration values in package parameters for SQL Server Integration Services 2012 (SSIS 2012).
• New Monitoring Console
  • (BIX-TFS-548): The "Package Performance History (Package, Tasks)", "Package Performance History (Package, Tasks, Data Flows)", and the Package Execution Trend reports have been upgraded to the latest version of our reporting format. These reports are now smoother and easier to use.
  • (BIX-TFS-739): Non-sensitive parameters can now be logged and displayed in the Monitoring Console.

Fixes

• Fix (BIX-TFS-733): Enabled Advanced Variable Logging option was ambiguous, renamed to Enable logging variable of data type Object.
• Fix (BIX-TFS-762): Some data flow components in SSIS 2008 and earlier packages weren't colored or appearing correctly in the Monitoring Console.
• Fix (BIX-TFS-763): Invalid characters (NULL) were being stored in the layout XML causing the Monitoring console to not show those packages.
• Fix (BIX-TFS-770 & BIX-TFS-1056): BI xPress Community Edition didn't have the correct reports enabled and threw an error when attempting to execute the Runtime Standard Deviation report (which is not included in BI xPress Community Edition).
• Fix (BIX-TFS-773): The community edition of BI xPress didn't include the SQL Server Data Tools 2012 integration.
• Fix (BIX-TFS-816): An error was being thrown immediately after installing BI xPress.
• Fix (BIX-TFS-933): Profile data is now stored using serialization methods.
• Fix (BIX-TFS-1055): The Running Packages report was not operating correctly.
• Fix (BIX-TFS-1068): The Download File Over HTTP/HTTPS snippet wasn't correctly downloading files. Now the snippet will download any file of any type.
• Fix (BIX-TFS-1086): Items were appearing as stopped in the Monitoring Console when they should appear as running/executing.

Version 3.5.0 [May 11, 2012]

New Features

• New Microsoft SQL Server 2012 Support
  • BI xPress now includes support for Microsoft SQL Server 2012. Support includes the ability to add the Auditing Framework, Notification Framework, and Snippets to SQL 2012 Integration Services packages. BI xPress also disables or removes some features that SSIS 2012 now includes natively. The BI xPress Monitoring Console also supports viewing SSIS 2012 packages that have been augmented with the Auditing Framework and also allows users to view packages of any version at the same time (up to 16).
• New Reporting Performance Monitor
• New Report Deployment Tool
  • (BIX-TFS-398 & BIX-TFS-436): BI xPress now has a Report Deployment Tool that enables users to move a report from one Microsoft SQL Server Reporting Services instance to another. Users and Reporting Services instances that are within the same domain can drag-and-drop reports and data sources from one environment (such as testing) to another (such as production). All users need to know are the addresses of each Reporting Services web service and have the correct permissions granted by their administrator.

Fixes

• Fix (BIX-TFS-327): Do not load a list of databases when opening the Auditing Framework.
• Fix (BIX-TFS-201): Object Reference Error thrown when removing invalid Configuration Path from list.
• Fix (BIX-TFS-300): The end date in the BI xPress Reporting features are off by +1.
• Fix (BIX-TFS-301): Remove ugly error message when evaluating Expression that include non-existant Variables.
• Fix (BIX-TFS-307): SSISDesignerComponents.ParseManager needs to be investigated for Bottleneck.
• Fix (BIX-TFS-309): Calculation ProfitMargin.mdxml Format needs to default to "Percent".
• Fix (BIX-TFS-310): Calculation ProfitMargin.mdxml incorrectly generates Profit Margin formula.
• Fix (BIX-TFS-364): Fix the issue where tasks are appearing blue (stopped) while the package is still running (green).
• Fix (BIX-TFS-367): Address the bug found in the Email Query Output Snippet.
• Fix (BIX-TFS-477): Fix issue with error reporting dialogue in BIDS addin when Package Configurations used against package that isn't in a solution.
• Fix (BIX-TFS-814): Resolved an issue regarding the BI xPress SSAS settings being saved correctly.
• Fix (BIX-TFS-817): Resolved an issue with the previous minor release that was showing a harmless error after launching the product with the BI xPress installer.

Version 3.2.2.116 [January 16, 2012]

Fixes

• Fix (BIX-1370 & BIX-1371): Incorrect database version was being set in the Package Builder.
• Fix (BIX-1297 & BIX-1340): Failed to Lock Variable Errors when duplicate PackageID found in Parent and Child Packages.
• Fix (BIX-1359): Could not connect to a remote server using SQL Authentication.
• Fix (BIX-1335): Snippet Wizard - Reading ADO Recordset Variable - Selecting Object Variable throws a "Editing variables with Object Datatype not supported" error.
• Fix (BIX-1355): Duplicate variables listed in Config Manager Screen.
• Fix (BIX-792): Error dialogbox resize ability Issue.
• Fix (BIX-840): BIConnection? MSDB Folder Browse doesn't change \XXXX to \ when you select .
• Fix (BIX-1356): Lock Icons not shoing up consistently.
• Fix (BIX-551): Auditing Framework - Unfriendly error thrown when Target Platform Version does not match Package Version.
• Fix (BIX-1354): Flickering issue with ReportViewer.
• Fix (BIX-1357): Report Viewer - Object Reference Error when changing from 'Extract/Load Detail' to Data Flow View.
• Fix (BIX-1358): When updating BI xPress to 3.2.1 the system wants to update the database but doesn't operate correctly.
• Fix (BIX-1349): Database Wizard - Create New Database Error Message redesign.
• Fix (BIX-1303): Notification Framework - pointing to an invalid path throws standard report error.
• Fix (BIX-1346): Cannot find column [SourceType].
• Fix (BIX-1232): Calculation Builder - "There is no MDX script defined in the cube yet" when using Calculation Builder.

Version 3.2.1.1214 [December 14, 2011]

New Features

• New Monitoring Console
  • (BIX-1139): Packages that have been stopped by the user, operating system, or other external process will now appear in blue in the Monitoring Console. Each package that has the Auditing Framework installed will allow recording of when and where a package is started. The Monitoring Console then monitors the status of each package that you have permission to view and displays the status of each package in the Monitoring Console. A package can be: not started (white), running (yellow), failed (red), successfully completed (green), and now stopped (blue).
  • (BIX-1322): Added a reconnect button in the Monitoring Console title bar

Updated Features

• Update (BIX-1327): Highlight invalid .dtsConfig paths in Configuration Manager. Now users will see invalid Configuration (.dtsConfig) File paths appear underlined and red for the selected packages in the Configuration Manager.
• Update (BIX-662): Monitoring Console - Rearrange the buttons so the Refresh button is in the standard "Apply" space at the end.
• Update (BIX-1300): Monitoring Console - Generic Locale being used instead of a region-specific locale for Row Count components created by BI xPress.
• Update (BIX-1253): Configuration Manager - Specified Path does not exist.
• Update (BIX-1311): Monitoring Console - Spelling and Grammar mistakes in the Tool-tips found in the Advanced Options.

Fixes

• Fix (BIX-855): Loading BI xPress BIDS addin manually doesn't fire highlighter for active package or when a package is opened.
• Fix (BIX-934 & BIX-949): Show bound value by reading Environment Variable in the Snippet Manager.
  Fix (BIX-649): Improvements when you hit cancel during password prompt of Password protected package deploy it keeps coming back.
• Fix (BIX-1103): When using Existing connection BIxPress database not validated for Sync.
• Fix (BIX-1337): Removed ZIP or Unzip Snippet due to the dependency on Microsoft J# to be deployed and J#'s end-of-life status by Microsoft. Use GZIP Compression snippets instead.
• Fix (BIX-1310): Check for and do not allow the BI xPress Database to be installed on Microsoft SQL Server 2000 database engines as well as check for compatibility levels greater or equal to 90.
• Fix (BIX-1341): SSIS 2005 Libraries were incorrectly being used when SSIS 2008 libraries should have been used.
• Fix (BIX-1342): Modified the message box verbiage in the Deployment Wizard when deploying configuration files encountered an error.
• Fix (BIX-1163): Encrypted Password Attribute for DSN (ODBC) Connection doesnt work.
• Fix (BIX-551): Auditing Framework - Unfriendly error thrown when Target Platform Version does not match Package Version.
• Fix (BIX-1133): Monitoring Console Error - Object reference not set to an instance of an object.
• Fix (BIX-420): Add Index on LayoutID and PackageName for SSISPackageExecutionTable.
• Fix (BIX-1163): Encrypted Password Attribute for DSN (ODBC) Connection doesnt work.
• Fix (BIX-1010 - 1012): Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=9.0.242.0.
• Fix (BIX-1122): Cannot delete a 'user created' Template Library "Object not set to an instance of an object".
• Fix (BIX-1129): Changes to variable list & scope not updating unless you click back and forth between Control Flow and Data Flow.
• Fix (BIX-873): BI xPress - Create Offline page when user is not connected to internet.
• Fix (BIX-1323): Monitoring Console - Invalid Object Name 'dbo.SSISPackageExecutionLog' "Error" should be converted to Dialog Box.
• Fix (BIX-1154): "Unable to delete specific Configurable Object" Notification in Package Builder instead of Error Message.
• Fix (BIX-1272): Auditing Framework - Grammar changes with new Auditng Configuration Properties.
• Fix (BIX-1317): BIxPress Options - Plugin Settings for Expression Highlighter cannot be Disabled and loading expression and configuratino overlay icons.
• Fix (BIX-551): Package Location Change Error: An OLE DB error 0x80040E14 (Could not find stored procedure 'msdb.dbo.sp_dts_listpackages'.).
• Fix (BIX-1254): Monitoring Console - Include Option in Connection information to Remember Password.
• Fix (BIX-1293): Typo - Tooltip for ADO Recordset logging.
• Fix (BIX-1167): Package Builder Wizard - Displays Snippet Wizard image.
• Fix (BIX-1130): Expressions list does not show confurations in the list, or in the count.
• Fix (BIX-1089): Snippet - script not supported in C# language - Uncompress GZip file.
• Fix (BIX-1088): Snippet - script not supported in C# language - Compres File to GZip format.
• Fix (BIX-1087): Snippet - script not supported in C# language - Call SSIS Package Programatically.
• Fix (BIX-1086): Snippet - script not supported in C# language - Read - Write Registry.
• Fix (BIX-1085): Snippet - script not supported by C# language - Reading ADO recordset variable..
• Fix (BIX-1320): Deployment Wizard - Change XML Config File Location "browse to location option".
• Fix (BIX-1126): Monitor LIVE won't allow 16th package to appear while 18 packages have been selected.
• Fix (BIX-1211): Monitoring Console - Report Tab's Refresh button does not refresh details.
• Fix (BIX-1269): Snippet Wizard - Zip/Unzip Snippet errors out if ActualSize, CompressedSize, and/or ProcessTimeSeconds Variables are not included.
• Fix (BIX-1214): Monitoring Console - Rearrange the buttons so the Refresh button is in the standard "Apply" space at the end.
• Fix (BIX-1322): Monitoring Console - Rearrange the buttons so the Refresh button is in the standard "Apply" space at the end.
• Fix (BIX-873): Error while loading SSIS Profile Settings. The process cannot access the file '..\My Documents\BI xPress\Profiles\Default\SSIS_SETTINGS.data' because it is being used by another process.
• Fix (BIX-1262): Expression refresh issue - icons not refreshed after you remove expression.
• Fix (BIX-1279): Invalid character in the name error when you enter invalid character in package name on package builder wizard.
• Fix (BIX-1295): Clicking on version update doesn't do anything in main screen.
• Fix (BIX-1302): Notification Framework - Creating New Config File Path creates Folder instead of dtsConfig File.
• Fix (BIX-1303): Notification Framework - pointing to an invalid path throws standard report error.
• Fix (BIX-1308): Monitoring Console - Row counts not being properly displayed in Control Flow and Reports.
• Fix (BIX-1312): Deployment Wizard - Create Rule to check Server name when clicking Re-Connect.
• Fix (BIX-1313): You get error when try to create new BIxPress database with non alpha-numeric character in the name.
• Fix (BIX-1315): ValidateAuditDBSchema Failed: Incorrect syntax near '.' ... when Database name has space.
• Fix (BIX-1316): When selecting a database, BI xPress will allow a non-existent database to be selected causing the default database of BIxPress to be used.
• Fix (BIX-1319): Deployment Wizard - Doesn't work well with SecureConfig

Version 3.2.0.731 [July 31, 2011]

New Features

• New Visual Studio Integration
  • (BIX-1166): Variable Dependency Scanner, Find, Rename, Delete Unused variables
  • (BIX-1216): This option allows you to mask values of variables and/or connection strings from being logged within the BI xPress Auditing Database.
• New Auditing Framework
  • (BIX-1244): Ability to configure auditing framework options from config file. Please refer to the Configuration File Options for more information.
    • You can turn on/off entire auditing framework from configuration file without removing framework from packages.
    • You can turn on/off variable logging from configuration file.
    • You can turn on/off connection logging from configuration file.
    • You can turn on/off real-time data flow monitoring, row count and data source related information.
    • You can exclude certain variables/connections from logging process (May be large variables or sensitive
  • (BIX-1222): Ability to configure maximum characters to be logged for variables. This is now supported through config file option.
• New Package Builder Wizard
  • (BIX-1270): Parameter button added for quick token insert on the package builder wizard screen (Click here to see screenshot)
  • (BIX-1274): New Package Builder Template - Cross Join Example Using Merge.

Updated Features

• Update (BIX-1245): Show hour glass rather than big loading dialog box to avoid flickering when you change execution in Monitoring console.
• Update (BIX-1250): User get warning about framework upgrade every time you close package. This warning is displayed when you don't include Realtime-DataFlow option or your package has older version of framework.
• Update (BIX-1242): Detect and merge existing configuration items for BI xPress config file when you apply auditing framework and generate config file option is checked.
• Update (BIX-1241): Implement MRU for server dropdown to show last 15 recently entered server name on most of the wizard using connection information.
• Update (BIX-1199): Added Load Profile Button on Notification Framework Screen.
• Update (BIX-1225): Auditing Framework - Remove all hard-coded database names throughout the Scripts containing the Database Objects.
• Update (BIX-1225): BIxPress takes long time to launch sometimes when it checks for update. This problem is corrected by placing update check in separate thread allowing so main UI is not frozen.
• Update (BIX-1260): Create missing folder when Config Path doesn't exist rather than showing "invalid characters found in the path" error when you use Secure Config Wizard.
• Update (BIX-1284): Auditing Framework - Should validate for invalid characters in the Connection Name when you click Next
• Update (BIX-1291): Config Editor should give option for case-sensitive and case in-sensitive search.
• Update (BIX-1289): Config Edit Search/Replace should allow search within Property Path for object name search/replace
• Update (BIX-1290): Config Editor should allow to clear search result set

Fixes

• Fix (BIX-1215): Monitoring console is frozen sometime or throws OutOfMemoryException when variable value is very large. This issue is resolved now but to limit how many characters can be logged by using the Auditing Framework's Configuration File Options.
• Fix (BIX-1228): Monitoring console throws OutOfMemoryException sometimes due to memory leak issue.
• Fix (BIX-910): You may get object reference is not set error when you try to configure package level properties (e.g. Name, CreatorName) in package builder wizard.
• Fix (BIX-1224): Configuration Wizard does not show variable for Notification Framework Wizard.
• Fix (BIX-1233): You may get access denied error when you try to delete folder/file in Template Browser in Package Builder Wizard.
• Fix (BIX-1240): Changing server name in the connection panel doesn't refresh database list on most of the wizards ( Notification, Auditing, Package Builder
• Fix (BIX-1243): Variable change history shows wrong result (shows variable changes of previous execution rather than current selection) on Monitoring Console.
• Fix (BIX-1247): Secure Config Wizard doesn't allow to edit configurable properties other than package level connections and variable.
• Fix (BIX-1157): Check/Uncheck parent node doesn't check/uncheck children nodes on Move/Copy variable dialog box.
• Fix (BIX-1210): User get object reference not set error rather than framework upgrade dialog box when one or more stored procedure missing in the audit database.
• Fix (BIX-1226): Auditing framework script is not generated in correct order causing dependency warnings when you execute it manually.
• Fix (BIX-1251): File is locked error is generated while using Zip/Unzip Script Snippet.
• Fix (BIX-1164): Package builder wizard search/replace functionality do not ignore unchecked items.
• Fix (BIX-1274): Modified packages are automatically saved without any prompt when designer window is closed. This issue behavior causes automatic checkout by some source control systems (e.g. Visual SourceSafe).
• Fix (BIX-1276): Config Editor window too small when you open it from BIDS or outside BIDS.
• Fix (BIX-1228): Monitoring console throws OutOfMemoryException sometimes due to memory leak issue.
• Fix (BIX-1278): Visual Studio crashes (On XP 32-Bit OS) when you try to click on Calculations Tab in Analysis Services Project.
• Fix (BIX-1283): Sometimes SSAS Calculation Builder Toolbar Icon disappears
• Fix (BIX-1288): Sometimes Smart rename preview doesn't show connections
• Fix (BIX-1206): Package builder wizard throws error Index was out of range. Must be non-negative and less than the size of the collection when you try to modify template.
• Fix (BIX-1286): Package Builder Wizard keeps prompting please select template after you delete file.
• Fix (BIX-1287): Config Edit Search/Replace doesn't work

Version 3.1.2.524 [May 24, 2011]

New Features

• New Notification Framework
  • Added support for SSL/TSL on SMTP Settings Screen.
• New Monitoring Console
  • Expression List now shows expression defined on precedence constraints.
  • Added "Delete Execution Log" right click option in the execution list.

Updated Features

• Update: Added Save and SaveAs buttons on Notification framework wizard to avoid confusion for modified settings.
• Update: SSIS and SQL Connectivity errors are more verbose and easy to understand.
• Update: Notification Framework - When you test SMTP settings you only get message saying Failure Sending Mail when wrong setting entered. Error should be more verbose

Fixes

• Fix: You may get the following error in Monitoring Console if no executions found or filter is applied InvalidArgument=Value of '-1' is not valid for 'index'. Parameter name: index
• Fix: Notification framework wizard doesn't prompt for save changes when you close wizard or you re-apply framework.
• Fix: Refresh on Monitoring Console is very slow sometimes after filtering execution list by package name. This problem is now resolved and filtering process is significantly faster compared to previous version.
• Fix: Changing value in package name filter doesn't reset execution list
• Fix: Search and Replace doesn't refresh current property grid on package builder wizard
• Fix: Selected items are not cleared from selection list when new location is selected on package selection screen.
• Fix: Launching package configuration wizard from designer (right click on package designer) doesn't show config listing screen and you are forced to select package.
• Fix: Expression list may throw the following error Length cannot be less than zero. Parameter name: length.
• Fix: Auditing Framework Wizard doesn't report login failure if you click refresh button.
• Fix: Deployment Wizard throws Invalid Path error when you move focus from folder textbox.
• Fix: Package Builder Wizard - Object reference not set Error occurs when double-clicking on folder inside of "Select Template Folder"
• Fix: Package Builder Wizard - The following error may occur sometimes when you select New Package From template option Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
• Fix: Package Builder Wizard - Editing property value on Search/Replace Dialogbox sometimes throws Object reference not set
• Fix: Layouts not deleted from Audit Database when you purge history or delete selected execution log

Version 3.1.1.58 [May 8, 2011]

New Features

• New Configuration Editor
  • XML Editing Support for dts Config files.
  • Search and Replace Support.
• New Monitoring Console
  • Runtime Standard Deviation Report: This report displays packages which are running slower or faster than usual trend. Difference of Current vs Avg Runtime is compared to Standard Deviation to determine considerable increase or drop in performance.

Fixes

• Fix: Launching Package Builder Wizard throws error - SetActionPara: Value cannot be null.
• Fix: BIxPress Database Sync Process doesn't update all objects in some cases.

Version 3.1.0.418 [April 18, 2011]

New Features

• New Configuration Editor
  • XML and SQL Configuration Editor (ConfigEdit).
  • New Package Builder Wizard
  • Template Parameters
  • Search and Replace Values for Package Builder Templates.
  • In-line editing support for object property editor.
  • Allow Delete action on the object explorer for selected template. Using delete option now you can delete 
  • unwanted objects from your template in one click.
  • Write Excel 2007 Template for Package Builder Wizard.
• New Monitoring Console
  • Provide option to pick Recovery Model, Initial DB Size and Growth for BI xPress Database on create database screen
  • Monitoring Console Server List is automatically populated based on recent connection history.

Updated Features

• Update: Double Click action should open next screen when you are on Snippet Browser or Package Template Browser Screen.
• Update: Add left to right arrow on the package selection screen just to make it consistent with right to left arrow.
• Update: Show only one error rather than showing multiple errors when BIxPress Addin Load fails.
• Update: Show only one error rather than showing multiple errors when BIxPress Addin Load fails.
• Update: Notification Framework Wizard - Automatically focus to appropriate screen when validation error occurs.

Fixes

• Fix: Renaming connection doesn't fire highlighter. Blue circle should go away if user rename connection or config file association is broken.
• Fix: Package Builder Wizard sometimes throws error: An error occurred while retrieving the value of property "CertificateContext". The error code is 0x80020009.
• Fix: Selecting new Template after first selection doesn't reload new Template.
• Fix: Performance History (Packages, Tasks, DataFlow) Report throws error: Conversion from type 'DBNull' to type 'String' is not valid.
• Fix: Wizard help button not working
• Fix: Instance names (local)\SQLEXPRESS and localhost\SQLEXPRESS are treated as two different connection settings by SmartRename of Configuration Manager causing multiple config file creation.
• Fix: Smart rename creates one config file for two different connections
• Fix: Sometimes you may get this error while loading BIxPress Addin: Problem registering PW.BIxPress.BIDSAddIn.Connect.BIxCommandCommonOptions command: Error HRESULT E_FAIL has been returned from a call to a COM component. Error HRESULT E_FAIL has been returned from a call to a COM component.
• Fix: Sometimes you may get this error when report viewer control: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
• Fix: Sometimes BI xPress menu in BIDS is blank. This happens usually when no project loaded in IDE.
• Fix: Sometimes you may get this error while loading BIxPress Addin: Error while loading command [BIxCommandSSISExpressionList]. Exception has been thrown by the target of an invocation. Could not load file or assembly 'Microsoft.DataWarehouse, Version=1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its...
• Fix: Calculation Builder throws error "Object Reference Not Set".
• Fix: Get File Properties Snippet generates code for parameters which are not checked.
• Fix: Execute Audit Schema Script throws Unable to cast object of type 'System.Data.OleDb.OleDbTransaction' to type 'System.Data.SqlClient.SqlTransaction' when "Use Existing Connection" option is selected and you try to upgrade auditing framework schema.
• Fix: When you try to save Script Snippet you may get Access Denied Error.
• Fix: When you try to save Notification Framework Configuration File you may get Access Denied Error.
• Fix: If Snippet name contains space at the end then add Snippet fails.
• Fix: On Secure Configuration Wizard when you have multiple packages listed and you try to double click on any configuration you may get Unable to cast object of type 'DevExpress.XtraEditors.Controls.ListBoxItemCollection' to type 'PW.Common.ListItemCollection'.
• Fix: Package builder doesn't use same path as displayed in the library path
• Fix: User with admin rights can't activate software and getting error account needs admin rights.
• Fix: Auditing Log Purge process doesn't delete records from SSISDataFlowExecutionLog and SSISPackageVariableLog
• Fix: Sometimes not all running packages displayed in the execution list. This happens when packages are running less than 5 seconds interval.
• Fix: Applying auditing framework sometimes throws Object reference not set error. This usually happens when row counts left unattached for some reason.
• Fix: UserName and MachineName are incorrect sometimes on Realtime Monitoring Console
• Fix: Variable change history shows blank without any other information
• Fix: Sometimes deadlock occurs when usp_SSISOps_Audit_OnPostExecute is executed after package/task completion
• Fix: When you select CSharp language option for auditing framework you may receive Binary code not found error and package may not execute.

Service Release [February 28, 2011]

Fixes

• Fix: Calculation Builder throws error "Specified cast is not valid".
• Fix: When SSAS is not installed you may get the following error while loading BIDS ... Error while loading command [BIxCommandSSASCalculationBuilder]. Exception has been thrown by the target of an invocation. Could not load file or assembly 'Microsoft.AnalysisServices.Controls, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
• Fix: You may get the following error on SQL Server 2008 R2: "Could not load file or assembly 'msmgdsrv' or one of its dependencies. The system cannot find the file specified."

Version 3.0.1.224 [February 24, 2011]

New Features

• New Snippet Wizard
  • Read from XML file
  • Write to XML file
  • Validate XML file against XSD schema file.
  • Write content to file - append mode (add to end of file)
  • Write content to file - overwrite mode
  • Write content to file - prepend mode (add to front of file)
  • Write content to file - Add header and footer or XML wrapping tags in file
  • Fast search and replace in ASCII file (supports large files)
  • Delete files older than specified number of days
  • Count lines in a file
• New Auditing Framework
  • Provided Remote folder browse for SQL Server and editable database folder path for New Database Dialogue box on Setup Database/Auditing Framework Screen.

Updated Features

• Update: Secure Configuration Wizard allows to encrypt connection which is being used by SQL Configuration. There should be a warning if user configure that connection by mistake.
• Update: Allow user to pick system generated connection and don't remove it during Re-Apply Auditing Framework Process.
• Update: On Reporting Console Execution list is not refreshed instantly after connecting to new server.
• Update: Secure Configuration Wizard allows to encrypt connection which is being used by SQL Configuration. There should be a warning if user configure that connection by mistake.

Fixes

• Fix: When using Multiple monitor all forms open in last monitor even though its not hooked up.
• Fix: Secure Configuration Wizard continues even though selected connection for SQL configuration not found in one or more selected packages. There should be an option for auto create connection if its missing.
• Fix: On Secure Configuration Wizard when you select EncryptAll and Reopen wizard it always goes back to EncryptSensetive. It doesn't remember encryption mode.
• Fix: On Secure Configuration Wizard Lock Icon is not visible for encrypted items when you perform edit.
• Fix: Installer doesn't auto upgrade certain files if you installing newer version.
• Fix: On Secure Configuration Wizard wrong warning displayed when you select SQL Configuration along with Smart Rename option turned on.
• Fix: On Secure Configuration Wizard changing SmartRename connection naming properties doesn't change file path and preview.
• Fix: Applying auditing framework overwrites existing Log Provider Settings.
• Fix: After upgrading to v3.0 or higher user get Invalid column "Connection" error on Reporting Console. There should a check for Schema Update when you change connection from ServerA to ServerB.
• Fix: Bottom pane not always visible in single package view on Reporting Console.

Version 3.0.0.21 [February 1, 2011]

New Features

• New SSAS Calculation Builder
• New Configuration Manager
  • SSIS Secure Configuration Wizard (Store Encrypted Passwords in configuration).
  • Smart Connection Rename and Shared Configuration.
• New Monitoring Console
  • Reports for DataFlow Component Performance and Task Performance
  • Connection Manager Logging
  • ADO Recordset Viewer
  • Connection information in Package Execution Report
  • Edit Server List option for SSIS Monitoring Console.
  • Sorting support on SSIS Monitoring Console. All list views now supports sorting (Error List, Execution List, Variable List, Connection List)
  • Auto refresh variable window for currently executing packages. Before it was only refresh after execution or if you checked show variable change history option. You will now see Green, Yellow or White Variable Records based on its change status. (Green=Never changed, Yellow=Just Changed, White Means=Changed few seconds ago and no more change after that)
  • Option to start preview of currently executing DataFlow automatically (See DataFlow Tab). When this option is checked you don't have to manually change data flow preview to see currently executing DataFlow.
• New Quick Deploy
• New Visual Studio Integration
  • Script compile option for SSIS 2008 Packages.
• NewGeneral Usability
  • Enter Key shortcut for package selection screens (Press enter key to refresh package list)
  • Enter Key shortcut for source/target selection on deployment wizard (Press enter key to refresh list)
  • Application skin support (See main Application Skin drop down on the main screen of BI xPress)

Updated Features

• Update: Performance improvements for script compilation during auditing framework wizard.
• Update: Remember expression window splitters and size.
• Update: Simple right click menu for package execution list.

Fixes

• Fix: You get an error "Failed to load BI xPress command" every time while opening Visual Studio if SSIS is not installed.
• Fix: Double clicking on highlighted item removes all selected items from the list.
• Fix: Packages with EncryptSensetiveWithPassword protection level continue to load even though you enter wrong password and because of this all passwords are cleared from connections.
• Fix: You get exception about "AlertKeyword cannot be null" while adding new alert filter for auditing framework.
• Fix: You get an error when you try to launch SSIS Monitoring console "Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies."
• Fix: After applying package name filter package executions are displayed in reverse order and all new executions are listed at the top in SSIS Monitoring Console.
• Fix: Setting visible execution count has no effect. List keeps growing after new executions are added.
• Fix: Variable list is not reset sometimes when you change execution.
  Fix: You get misleading error "Object reference not set" sometimes when layout information is missing.
• Fix: When dataflow is empty you may get this error while applying auditing framework€¦."Item has already been added. Key in dictionary: Key being added: ''
• Fix: All options on Setup Database screens are grayed out.
• Fix: Notification framework wizard validates options even though you are closing screen by pressing cancel button or [x] in the caption bar.
• Fix: Variable list is not reset sometimes when you change execution.
• Fix: You may get long line and visual studio IDE performance warnings while opening packages after applying auditing framework. New version breaks long line into multiple lines which will eliminate this issue.
• Fix: Purging all records doesn't clear Monitoring Console Diagram and Execution List.
• Fix: When is checked then you get error "The path is not of a legal form."
• Fix: After deleting executions list sorts in wrong order.
• Fix: Variables not refreshed for first package when you launch SSIS Monitoring Console.
• Fix: On notification wizard saving config file to new location doesn't work if config file is not found at the new location.
• Fix: Adding new alerts in auditing framework filter alert UI doesn't work.
• Fix: MachineName, ExecutionAccountName,ExecutionMode,ExecutionStatus parameters are always grayed out.

v2

Version 2.3.1.106 [October 6, 2010]

New Features

• New Monitoring Console
  • Advanced logging options for variables allows the user to track variables of any data type (including Object, numbers, datetime, and GUIDs), log the full values of variables, and log ADO Recordsets in plain text.
• New Snippet Wizard
  • Script Snippet that reads recordsets
• New Package Builder Wizard
  • Allows executable selection for "New Template From Selection" option
  • Allows multiple items check/uncheck by clicking folder node
  • Allows object selection in more flexible way when launched from menu without selecting any items in the designer
• New Monitoring Console
  • View full screen html for variable change history grid.
  • Auto refresh option to disable refresh of variable changes

Updated Features

• Update: Performance improvements in expression highlighter. Now it doesn't scan expressions when you switch from variable window to package designer.
• Update: Performance improvements in expression highlighter. Now it doesn't scan expressions when you rename component or add new component.

Fixes

• Fix: Cannot resolve collation conflict for equal to operation when TempDB is setup with different collation than BIxPress database.
• Fix: Package Builder Wizard - "Object reference not set" error is thrown when you check/uncheck folder node on package object explorer screen.
• Fix: Variable tracking sometimes creates locking issues when variable is evaluated as expression.
• Fix: BIxPress main menu randomly disappears from BIDS.
• Fix: Errors/Warnings are not cleared from Errors/Warnings list when you click on a different package with no errors.
• Fix: Variables other than String datatype (e.g. Int,DateTime,Object) not tracked even though variable tracking option is on.
• Fix: Notification framework always sends high priority email even though its set to DELAYED.
• Fix: Purge record fails with datatype conversion error.
• Fix: Monitoring Console try to render reports even though connection fails and because of this LIVE Mode is disabled.
• Fix: Editing/Previewing notification email template throws error.
• Fix: Notification wizard validates all options even though cancel button is clicked.
• Fix: C# Script Language option on auditing wizard doesn't log connection/data source information.

Version 2.3.0.820 [August 20, 2010]

New Features

• New Auditing Framework
  • Provided an option to setup new database for auditing framework (see on the main screen of standalone application).
  • Allow changing database location when creating new database for auditing framework.
  • Auditing wizard has new option to continue package even though auditing database connection failed.
  • Create New Auditing database option on the auditing connection information screen.
• New Monitoring Console
  • This feature allows you to monitor data flow progress visually in real-time. When you install new version of BI xPress you will see DataFlow tab along with control flow and Reports.
  • DataFlow diagram (Component status, Runtime and Row count transferred from each path)
  • List of dataflow for selected package
  • Preview of selected package controlflow
  • This feature allows you to monitor multiple packages in the same console. You can monitor up to 16 packages in matrix mode.
  • To view packages you have to check packages in the execution list. You can switch to full screen mode by clicking on full screen icon found on the top-right corner on each package block in matrix mode.
  • This feature allows you to view variable value history in real-time. In order to view variable value changes you must enable option on the auditing wizard.
  • This feature allows you to view the current iteration above Task icon in control flow diagram. This feature requires 
  • Variable Tracking option turned on.
  • Filtering enhancements for reports and package execution list of control flow diagram
  • With this version now you can open most common reports using right click popup menu in execution list. Most of reports can be executed for 10 days/30 days and 90 days interval without changing parameters manually. For any trend report you will see two more options (a) 12 months (b) 52 weeks options.
  • Display all packages monitored for a selected time-frame with the Package Performance History report. You can click on the plus sign to see a full performance detail graph with runtime and execution period. When execution failed for certain periods of time, you will also see red bar in the performance trend line.
  • Options to delete execution records from report and execution list
  • Real-time Variable Monitoring
  • "Recent Execution Summary" shows same information as "Recent Execution Detail" except task detail. This report is much faster compared to "Recent Execution Detail" report because it doesn't display task detail of each execution.
  • Option added to view all errors and variables in full screen mode on Control Flow diagram.
  • Provided an option to save control flow image as *.png, *.bmp or *.jpg.
  • This version allows to open Report Viewer on the machine where SQL Tools/SSIS Runtime not installed. This makes it possible to install BIxPress on any machine for monitoring purpose. In the previous version SSIS Runtime was required before you can access any option of BIxPress.
  • On Double click toggle Zoom state between 100% and Zoom To Fit.
  • Provided an option to change control flow diagram refresh speed in case user is having performance issue.
  • Allow more than 999 records in execution list on control flow diagram.
  • Show variable window in the control flow diagram.
  • Give option to expand containers in control flow diagram so child objects can be displayed for monitoring.
  • Ctrl + MouseWheel for diagram zoom in /zoom out and Mouse wheel/arrow keys for scrolling.
  • Redesigned SSIS Monitoring Console UI for easier navigation between reports and control flow. Provided Back button and Tabs for each section (Reports, ControlFlow, DataFlow). Hide diagram toolbar when report is visible. 
  • Use Toggle State button rather than check boxes for each main option to show/hide window. Provided close button for each window.
  • Show confirmation prompt before auto upgrading packages. Auto upgrade is trigged when packages created with lower version of BIDS processed by BIxPress when higher target platform is selected. (e.g. If target platform is 2008 and you apply auditing framework to package created by 2005). Once package is auto upgraded it can not be 
  • opened by lower version of BIDS.
• New Expression Manager
  • Expression manager to organize user defined expressions
• New Package Builder Wizard
  • Option to exclude certain folders from Template folder list on the package builder wizard. This option helps to hide unwanted folders (e.g. folders created by source control software)
  • Option to browse Template Library Location on the package builder wizard. Previous version allowed to save templates outside the library location which created confusion because templates saved outside library location are not visible in the Template browser.
• New Deployment Wizard
  • Deployment wizard now displays sorted list of packages when connected to SQL Server or SSIS Package Store.
  • Add/delete folder option for target tree-view on the deployment framework wizard.
• New General Usability
  • Send error option when exception is occurred.
  • All wizards now show completion message after processing is done.

Updated Features

• Update: Hide variable row in the execution report when no variable found.
• Update: More cleaner look of SSIS Monitoring console by moving uncommon options under Advanced Options screen. You can open options dialogbox by clicking "Advanced Options" button at the top.
• Update: For trial version - Register software screen is only displayed when you launch wizard.
• Update: Performance improvements for execution list refresh. Now list doesn't flicker when its refreshed and its much faster.
• Update: View Report right click menu of Solution Explorer is moved under main menu bar "BI xPress" to improve performance.
• Update: View report now check for schema upgrade.
• Update: Wrap audit db sync script in transaction so if something goes wrong during database update all changes can be rolled back to restore database to its previous state.
• Update: Performance improvements in expression highlighter.
• Update: Store full connection string rather than individual elements in the auditing framework xml config file.
• Update: All procedures reading data from auditing database is using READ UNCOMMITTED transaction mode to avoid any possible locking issue in multi user environment.
• Update: Validate FailPackageOnFailure property when updating auditing framework. This when FailPackageOnFailure property is set for any task in the package if that task fails package is terminated without properly logging package end time.

Fixes

• Fix: After applying/removing auditing framework sometimes union all component mappings are lost for certain columns. This problem only occurs if all inputs don't have exact same column names.
• Fix: After applying auditing framework row count is only attached to first output of XML Source.
• Fix: SSIS monitoring console throws OutOfMemory exception when running static reports.
• Fix: Sometimes SSIS Monitoring Console takes focus away from any other Active window.
• Fix: Maintain scroll position of package execution list after refresh.
• Fix: If parent package is calling child package using Execute Package Task and child package execution fails control flow diagram doesn't show execute package task in Red.
• Fix: Package builder wizard doesn't detect dependencies for BulkInsert Task and Execute Package Task.
• Fix: Password node is added in the config file even though you select windows authentication for auditing database. Because of that user get can not decrypt node error.
• Fix: Selected package count not refreshed after scanning framework on package selection screen of auditing and notification wizard.
• Fix: Sometimes you may get error on control flow diagram about missing layout information even though you already applied auditing framework to that package.
• Fix: You may get "Invalid file name" error when saving process log. This error occurs when you don't specify file extension for log file.
• Fix: Auditing framework doesn't log row count due to overflow error if row count is greater than 2 billion.
• Fix: BIDS updates auditing framework based on last auditing framework wizard setting rather than package auditing framework setting.
• Fix: Sometimes config file path not refreshed on auditing framework options screen.
• Fix: Sometimes package builder wizard doesn’t add precedence constraints and you get warning … Precedence constraint already exists.
• Fix: When child task fails it doesn’t show parent container in Red on control flow diagram. So when container is collapsed you will see all green even though certain tasks inside container failed.
• Fix: On the auditing framework wizard connection options when you click on the database drop down it doesn't open in the first click and you have to click it again.
• Fix: When you click on "BI xPress" menu in BIDS it shifts to right.
• Fix: Sometimes "access denied" error is thrown when previewing notification email templates.
• Fix: Package execution list doesn't maintain focus on the selected item after refresh.
• Fix: Sometimes "access denied" error is thrown when previewing notification email templates.
• Fix: Sometimes on the control flow diagram tab package is changed to different package automatically.
• Fix: Auto update from BIDS always points to trial download page even though you are registered user.
• Fix: Sometimes execution list doesn't show running packages when there are no previous executions found.
• Fix: Setup shows uninstall message even though you are upgrading to newer version.
• Fix: Password protected package throws error even though you enter correct password.
• Fix: Package diagram does not scale to fit when you click on Zoom to fit option.
• Fix: Invalid characters are allowed in profile name.
• Fix: Deployment wizard sometimes hides bottom panel of package explorer and controls are overlapped.
• Fix: Deployment wizard keeps prompting password even though you hit cancel when deploying password protected packages.
• Fix: Package Builder Wizard prompts read-only package file warning during create template action.
• Fix: Windows Authentication doesn't work in Notification Framework.
• Fix: Use Existing Connection Manager sometimes removes connection manager from the package you are modifying.

Version 2.2.1.49 [April 9, 2010]

Updated Features

• Update: In this version we decided to move BI xPress tool bar commands to top "BI xPress" menu bar for performance and scalability reason. All other right click menu items are still available. This will make over all visual studio experience much faster.
• Update: Red and Green colors are changed to more softer colors for execution list in report viewer so its easier to see execution details.

Fixes

• Fix: Visual studio may crash or sometime you may notice extremely slow performance when debugging /opening/closing packages in Visual Studio
• Fix: When "Default" protection level is selected on deployment configuration screen you may get an error "Value doesn't fall in range"
• Fix: Visual studio crash when you uncheck or check commands from options dialogue box
• Fix: UI theme is not initialized when you open certain forms after BI xPress Add-in is loaded.

Version 2.2.0.46 [April 6, 2010]

New Features

• New Monitoring Console
  • This feature allows you to monitor local or remote package execution visually (just like package debugging in BIDS). You can view realtime controlflow diagram of running/completed packages.
  • This feature allows you to log values of user variables once package execution is completed. You can optionally disable this feature on Logging Option Tab of auditing framework wizard.
  • Schedule audit log purging option
• New Auditing Framework
  • Added option to select existing connection for auditing rather than creating new connection and configuration file (See Auditing Wizard Option screen)

Updated Features

• Update: There are some performance improvements made in this version. You may notice 30-40% faster add-in load time and overall quicker response time in BIDS.
• Update: Right click menu items for auditing and notification in BIDS solution explorer are now accessible with single click.

Fixes

• Fix: Auditing Database with a case-sensitive collation sometimes throws error.
• Fix: Sometimes unchecking commands from options dialogue box crash Visual Studio.
• Fix: Scan packages for Auditing/Notification framework has wrong behaviour when "Uncheck" option is selected on the Options dialogue box.
• Fix: Sometimes you may receive failed to lock variable in OnPreExecute or OnPostExecute events when ScriptTask added by Auditing framework wizard is executed.
• Fix: Sometimes you may receive "Object reference not set to an instance of an object" error when you try to edit property on package builder wizard.
• Fix: Package builder wizard doest rename internal package name to match with new package file name entered on the first screen.
• Fix: Deployment wizard fails to copy file when target file already exists and its set as read-only.
• Fix: Recent execution report doesn't update row count until package execution is completed.
• Fix: Sometimes auditing framework schema is not validated when you go to process summary screen from auditing framework options screen.
• Fix: Auditing framework schema objects are dropped without prompt when schema updates found. This behavior is changed so it will prompt user first before dropping schema changes.
• Fix: Sometimes MultiCast component in data flow can cause error when you try to apply auditing framework.
• Fix: Sometimes script component in data flow can attach wrong output to downstream component when you try to apply auditing framework.
• Fix: Sometimes package executions are not logged and reports may throw error if Local Date Format is other than MM-dd-yyyy (If Server is configured to use British date format "dd-mm-yyyy" then package execution is not logged because of date conversion error).
• Fix: "File In Use" Snippet is not working.
• Fix: Saving/Creating package templates sometimes throws "Access Denied" error on Vista / Windows 7 machine when UAC is turned on.
• Fix: Notification framework email shows "0 Sec" runtime when package execution time is more than 60 seconds. It shows correct runtime when execution time is less than 60 seconds.
• Fix: Renaming connections sometimes throws error in package execution log when auditing framework is applied. 

Version 2.1.1.210 [February 10, 2010]

Fixes

• Fix: Removing or Reapplying auditing framework sometimes attach wrong output to the destination component. This only occurs when multi output component (e.g. SCD, Conditional Split) attached to the destination component.

Version 2.1.0.127 [January 27, 2010]

New Features

• New Auditing / Notification Framework
  • This feature will scan packages and find out which packages have auditing framework or notification framework.
• New Package Builder Template
  • Added delete folder option for package builder template browser.
  • Added edit library option for package builder template browser.

Updated Features

Update Added the following new package builder templates (listed by category):

• Data Cleansing
  • Address parsing, cleaning and standardization to proper case (USPS Standard)
  • Change date format
  • ProperCase - Standardize name, address, title and notes
  • Replace alpha-numeric characters
  • Replace NULL with user defined Value
• Zip / Unzip
  • Unzip compressed files/folder
  • Zip Files or Folders
• XML Processing
  • Looping through XML Nodes
  • Load XML - Data Stored As Attribute
  • Load XML - Data Stored As Element
  • Load XML - Data Stored in Multi Level Elements
  • Load XML - Data with In-line Schema Definition
• Excel Processing
  • Read data from Excel 2007 (XLSX)
• FTP Operations
  • Secure FTP - Download/Upload files
• Data Loading Patterns
  • Upsert destination (Bulk update or insert records)
• Advanced Email
  •  Send HTML email, use HTML template and automatically replace variable place holders
• Looping Various Objects
  • Loop through folders and sub-folders
  • Loop through sorted files by date, size or name

Fixes

• Fix: View Package may fail on Vista/Windows 7 when UAC is enabled.
• Fix: Sometimes "Create new package From template" option refers to different package other than selected template.
• Fix: SMO package template doesn't work on SQL Server 2008.
• Fix: "Files older than N days" snippet doesn't work on SQL Server 2008.
• Fix: Package builder screen shot option doesn't work from main screen.
• Fix: On snippet wizard if folder is selected it throws "Object reference not set error".
• Fix: Report viewer shows wrong instructions when Auditing Framework object(s) not found.
• Fix: When Snippet wizard is launched when Data flow designer is active you receive an error.
• Fix: Auditing/notification wizard fails when package file is read-only (Mostly happens when you using Source Control).
• Fix: Sometime expression list doesn't show up after clicking expression list tool bar button.
• Fix: When you create new package from template using package builder wizard new package ID is not generated. It keeps the same PackageID as template package.
• Fix: Package layout/Annotations are lost when new package is created from template using package builder wizard.
• Fix: Password protected package always shows error in the process log screen at the end of the wizard (e.g. Audit, Notification, Snippet wizard...) even though you entered correct password.
• Fix: Sometimes package builder wizard corrupts new template when its created from selected object in BIDS designer. This is usually occurs when you don't select both start and end tasks connected by precedence constraint.
• Fix: Package builder wizard allows to proceed next screen even though template load fails.
• Fix: Duplicate library name allowed for snippet wizard/package builder wizard browser screen.
• Fix: You can not create package templates using package builder wizard from password protected package.
• Fix: Package builder/Snippet tool bar buttons and right click menu not disabled for file types other than *.dtsx.

Version 2.0.0.1013 [November 13, 2009]

New Features

• New Package Builder Wizard
  • Package Builder Wizard for quickly building packages from several predefined templates.
• New Expression Editor
  • Added 3 new DateTime expressions for BI xPress Expression Edit dialogue box.
  • Show correct icon instead of generic task icon for 3rd party tasks in Expression List window.

Fixes

• Fix: Improved BI xPress Add-in load time by removing some menu items from top menu. Most of the functionality is available via Right click menus or Tool bar Buttons.
• Fix: Variable value is not changed after you close Variable Edit form (SSIS Variable Tool bar).
• Fix: Changing expressions from BI xPress Expression Editor form doesn't mark package dirty.
• Fix: After closing Package Configuration Dialogue box expression icons are reset.
• Fix: Installer doesn't set write Permission for Snippet folder. This creates problem for limited rights users or any user running Vista/Windows7 with UAC turned on.
• Fix: Add/Remove Auditing Framework Fails when DataFlow has Merge Join in SSIS 2005.
• Fix: BI xPress Expression editor doesn't show proper error message like Microsoft Expression Editor.
• Fix: All Type Casting Expressions doesn't work.

v1

Version 1.3.1.831 [August 31, 2009]

New Features

• New Compile Script
  • This version introduced compile script tasks/components option to compile any all script tasks/component of single or all packages of SSIS project.

Fixes

• Fix: "Object reference not set" error is thrown when you save new snippet.
• Fix: When Sort Plug-in is enabled you can not rename file name in solution explorer. However you can rename "file name" property using using Properties window.
• Fix: Auditing/Notification framework wizard fails with "Could not find any resources appropriate for the specified culture or the neutral culture" error.

Version 1.3.0.825 [August 25, 2009]

New Features

• New Deployment Wizard 
  • New option added on the deployment wizard to PreCompile Script Tasks and Script Components (in DataFlow)Deploy selected packages along with their folders using Single Click.
  • Delete selected Folder Structure (along with packages) using Single Click. In the previous version you can only delete folder if its empty or no child folder under that. New version removes this restriction and made it far easier to Deploy and maintain SSIS Folders.
• New Notification Framework
  • Added HTML Template option for Email Notification. Now you can customize look of your email body using HTML email template.
  • Log to Windows Event Log option added.
  • Log to File option added. You can also define for how many days you want to keep log files.
• New Visual Studio Integration
  • Full Screen command added in BIDS Add-in. Now you can Hide/Restore all tool bars and windows to get Full Screen mode using Keyboard Shortcut Alt + Enter or tool bar button click.
  • Sort Packages by clicking sort button on the tool bar (No need to right click on the packages folder node) .
• New Snippet Wizard
  • New Snippet Editor (Edit/Delete or Create your own snippets for VB.net or C#)

Updated Features

• Update Snippets: New Snippet Editor (Edit/Delete or Create your own snippets for VB.net or C#)
  • Check Folder Exists
  • Read/Write Registry Key
  • Execute SSIS Packages Programmatically and pass variables
  • Read File Content into variable
  • Read File Line By Line
  • Read-Write Variables Functions
• Update: Any objects created for auditing framework is now set to Required Transaction = NotSupported so on rollback it keeps Auditing History

Fixes

• Fix Notification Framework: Alert message filter file "SSISAlerts_DataFile.txt" is overwritten when you upgrade to new version of BI xPress.
• Fix Deployment: When you delete folder with sub folders in Deployment Package Explorer you receive error.
• Fix Deployment: When you have SQL Server configuration defined and Deploy Config option is checked then you will get "illegal character in the path error".
• Fix Snippets: Parameter Binding Issue for Archive File Snippet.
• Fix Snippets: When snippet wizard is launched from standalone application it doesn't add snippet variables to the selected package.
• Fix Snippets: Variables created using Snippet Wizard doesn't have Scope and when you try to delete variables it shutdown BIDS after throwing error.
• Fix Auditing Framework: SSISOps database creation fails when Database is set to case sensitive.

Version 1.2.1.66 [June 6, 2009]

New Features

• New Package Sorter
  • "Sort Project Items" menu is now available for "Data Sources" Expression Highlighter

Fixes

• Fix Expression Highlighter: doesn't work when you have only SQL 2005 components installed. Any machine with SQL 2008 components doesn't have this problem.
• Fix: When Sort Plug-in is enabled you can not rename file name in solution explorer. However you can rename "file name" property using Properties window.

Version 1.2.0.71 [July 1, 2009]

Features

• New Expression Highlighter
• New Expression List
• New Snippet Wizard
  • Enhanced Expression Editor with Snippets
  • SQL Query to HTML Generator (Save to File or Email)
  • Check if File is locked
  • Snippet count label and snippet location link on the snippet browser screen.
  • View description option added on the snippet browser screen. Description also contains links for download files (Zip snippet requires J# re-distributable DLLs if not installed)
• New Visual Studio Integration
  • Variable Copy/Move to New Scope (Anywhere with in SSIS Project)
  • Improved Variable Edit
  • Automatic products update notification feature for BIDS Add-in. In the previous version this feature was available only for standalone application
• New Package Sorter
  • Sort packages by name, date modified or size
• New Notification Framework
  • CC and BCC options for notification framework

Updated Features

• Update General: Profiles are now stored in Personal folder (XP: :\Documents and Settings\\My Documents\BI xPress, Vista: :\Users\\Documents\BI xPress ) instead of Program Files\Pragmatic Works\BI xPress to avoid any read/write permission issues. This issue occurs when you are running as non-admin user or running VISTA with UAC turned on.

Fixes

• Fix Snippets: Any parameter bound with connection property always reads ConnectionString property instead of selected property.
• Fix Snippet: In Send Advanced Email snippet blank values for BCC or CC Email field stored in variable in causes error.
• Fix Snippets: "Object reference not set" error occurs when snippet wizard is launched from stand alone application (this only occurs when selected package is different version than selected platform).
• Fix Notification Framework: From email address is not saved when wizard is closed.
• Fix Notification Framework: When notification wizard is launched from BIDS "Loading.." message doesn't go away.
• Fix Notification Framework: Email subject always shows "[0] Warning(s)" instead of actual warning count.
• Fix General: Check for products update every 5 days instead of every day.

Version 1.1.0.61 [June 1, 2009]

Features

• New Snippet Wizard
  • This version introduced new snippet wizard to add reusable code from snippet library. Snippet framework is extensible framework to create reusable scripting code and control flow. The Current version only supports Script based snippets and does not have Snippet Editor to create your own snippet. A future version will include that feature. Using snippet wizard you can select snippet, script language and parameters. The following snippets are available in the current version. More snippets will be added in next version. You can access snippet feature from BIDS by right click in control flow. The New Snippet Wizard can do the following:
  • Zip/Unzip file
  • Read file properties (Size, Date Created, Date Last Accessed, IsHidden, IsReadOnly )
  • File Exists
  • Download file over HTTP (Supports authentication and Proxy Settings)
  • Send HTML Email
  • Archive file (Copy/Move file to new location and rename file to add Timestamp in user defined pattern)
    Added an option to close wizard automatically once processing is completed. This option is enabled by default when wizard is launched from BIDS
• New Auditing Framework
  • New version will now attach row count for OLEDB Command Transformation so you can see how many rows processed by OLEDB Command in data flow
• New General Usability
  • Added Profile drop-down in standalone application. You can now switch current profile by selecting from drop-down.

Fixes

• Fix: When package name contains invalid character (e.g. "[" ) deployment fails.
• Fix: Deployment tree view doesn't remember root node selection
• Fix: Finish button remains grayed out after deployment is completed.
• Fix: Certain activities performed by system (e.g. Disk Defragment, System Updates) sometimes requires Software Activation.

Version 1.0.0.422 [April 22, 2009]

Features

• Numerous Bug Fixes.
• Visual Studio 2005/2008 Integration.
• Completely redesigned easy to use user interface.
• Completely redesigned deployment wizard.
• Auto detect SSIS package changes and synchronize auditing framework changes in BIDS.
  Framework for future improvements with Visual Studio Add-in for many new features which can greatly improve productivity for SSIS, SSAS and SSRS development.