ssis
ssisUnit 0.60
A unit testing framework for SQL Server Integration Services more>> A unit testing framework for SQL Server Integration Services
ssisUnit was designed to be a unit testing framework for SQL Server Integration Services. It is loosely based on the xUnit family of unit testing frameworks, but is tailored to better support the SSIS environment.
One of the bigger differences is that you do not have to write code to create the unit tests. Instead, we have taken a declarative approach to specifying the unit tests. The test information is all stored in XML files. Since many SSIS developers do not have a background in coding traditional applications, we felt it was important to deliver something that did not require an understanding of .NET development to use.
ssisUnit supports task level testing in SSIS. Any control flow task can have a set of tests created around it. This level of granularity in testing can make testing complex packages much easier.
System requirements:
- SQL Server 2005 or 2008
- .NET Framework
BIDS Helper 1.3.0.8
Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 BI Development Studio. more>> Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 BI Development Studio.
BIDS Helper was designed to be a Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 BI Development Studio. (BIDS)
Main features:
- Analysis Services
- Aggregation Manager
- Calculation Helpers
- Column Usage Reports
- Delete Unused Aggregations
- Deploy Aggregation Designs
- Deploy MDX Script
- Dimension Data Type Discrepancy Check
- Dimension Health Check
- Dimension Optimization Report
- Measure Group Health Check
- Non-Default Properties Report
- Printer Friendly Dimension Usage
- Printer Friendly Aggregations
- Tri-State Perspectives
- Similar Aggregations
- Smart Diff
- Show Extra Properties
- Update Estimated Counts
- Validate Aggregations
- Visualize Attribute Lattice
-
- Integration Services
- Create Fixed Width Columns
- Deploy SSIS Packages
- dtsConfig File Formatter
- Expression and Configuration Highlighter
- Expression List
- Fix Relative Paths
- Non-Default Properties Report
- Pipeline Component Performance Breakdown
- Reset GUIDs
- Smart Diff
- Sort Project Files
- SSIS Performance Visualization
- Variables Window Extensions
-
- General
- Enable/Disable features
System requirements:
- SQL Server 2008
- SQL Server 2005
Enhancements:
- An issue where the configuration properties for the SSIS Deploy Package feature was not always available has been addressed.
- The Dimension Health check now support Teradata as a data source.
SQL 2005 Service Manager 2.0.0.5
A replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server more>> A replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server
The SQL 2005 Service Manager was designed to be a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server.
It allows the management and monitoring of all local SQL Server related services from a convenient system tray application for all editions of SQL Server 2000, 2005 and 2008.
To use SQL2005 Service Manager simply unzip the downloaded file into a folder and double click on SQL2005 Service Manager Setup.msi to install. For the Windows Vista version, please read the Install Instructions in the zip file and ensure the SQLServiceManager service is started before using the application.
The behaviour of SQL2005 Service Manager is very similar to that of the SQL Server Service Manager that is part of Microsoft SQL Server 2000, one exception being that it will always start minimized in the system tray. Another is that the tool only manages local instances.
The system tray icon has a right click menu allowing service and instance selection and control of the currently selected service. Double clicking on the icon or choosing Open SQL2005 Service Manager from the menu will bring up the familiar user interface allowing instance and service selection and control of the selected service. The installer adds a shortcut to your Startup folder so if you dont want it to start automatically simply delete the shortcut.
Main features:
- Manage SQL Server, SQL Agent, Analysis Services, Full Text Search, MSDTC,SSIS and Reporting Services
- Supports all SQL2008, SQL2005 and SQL2000 Editions
- Manage and monitor local services from the system tray
System requirements:
- .NET Framework 2.0.50727
Enhancements:
- Added compatability for SQL 2008 RC0 and filtered SQL 2008 Express SQL Agent service
File Watcher Task 1.2.5.73
File Watcher Task watches a folder waiting for files and when an available file is found the task completes more>>
The task detects changes to existing files as well as new files; both actions will cause the file to be found when available. A file is available when the task can open it exclusively.
This is important for files that take a long time to be written, such as large files, or those that are just written slowly or delivered via a slow network link. The task can also be set to look for existing files first, before starting the monitoring phase.
The full path of the found file is returned in one of the three ways:
- The ExecValueVariable of the task.
- The OutputVariableName when specified.
- The FullPath variable of the OnFileFoundEvent.
Advanced warning of a file having been detected, but not yet available is returned through the OnFileWatcherEvent. This event does not always coincide with the completion of the task, as completion and the OnFileFoundEvent is delayed until the file is ready for use.
This event indicates that a file has been detected, and that file will now be monitored until it becomes available. The task will only detect and report on the first file that is created or changes, any subsequent changes will be ignored.
The component is provided as an MSI file, however to complete the installation, you will have to add the task to the Visual Studio toolbox manually. Right-click the toolbox, and select Choose Items.... Select the SSIS Control Flow Items tab, and then check the File Watcher Task from the list.
Data Generator Source Adapter 1.1.0.23
Data Generator Source Adapter generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline more>>
This component is used by us to do testing of the pipeline and components downstream. Previously we would have used a script component (as a source) to generate the rows but found ourselves rewriting the code too often so created this component.
The component is provided as an MSI file, however to complete the installation, you will have to add the transformation to the Visual Studio toolbox manually. Right-click the toolbox, and select Choose Items.... Select the SSIS Data Flow Items tab, and then check the Data Generator Source from the list.
Expert Logger 1.0 Beta
Logging SSIS packages at a time with a good user customizable interface. more>> Expert Logger 1.0 Beta is a user-friendly tool that provides a unique feature to track the execution of the packages so that it can be utilized for debugging or analyzing performance later.
Expert Logger provides a great solution to set the logging features of the packages batch wise i.e. set log features to all the packages at a time.
Major Features:
- Supports Flat File logging only.
- Supports packages stored in hard drives only.
- Supports 18 types of logging.
- Logs up to 7 types of information regarding the package.
- Compatible user interface.
Requirements: SQL Server 2005
- Page: 1 of 1
- 1
