Software Listing of Author : "Sqlis.com"
- Checksum Transformation
- License: Freeware
- Price: -


Checksum Transformation computes a hash value, the checksum, across one or more columns The Checksum Transformation will compute a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services, for use within the pipeline without code or a SQL Server connection. All input columns are passed through the transformation unaltered, those selected are used to generate the checksum which is passed out through a single output column, Checksum. This does not restrict the number of columns available downstream from the transformation, as columns will always flow through a transformation. The Checksum output column is in addition to all existing columns within the...
- Platform: WinOther
- Data Generator Source Adapter
- License: Freeware
- Price: -


Data Generator Source Adapter generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline Data Generator Source Adapter will generate random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated. 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....
- Platform: WinOther
- File Watcher Task
- License: Freeware
- Price: -


File Watcher Task watches a folder waiting for files and when an available file is found the task completes The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for onward use within the package. 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...
- Platform: WinOther
- Regular Expression Transformation
- License: Freeware
- Price: -


Regular Expression Transformation exposes the power of regular expression matching within the pipeline The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. If all columns selected pass their tests then rows will be passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output. This transformation is ideal for validating data through the use of regular expressions. You can enter any expression you like, or select a pre-configured expression within the editor. You can expand the list of pre-configured expressions yourself. These are stored in a Xml file, %ProgramFiles%Microsoft SQL Server90DTSPipelineComponentsRegExTransform.xml....
- Platform: WinOther
- Row Count Plus Transformation
- License: Freeware
- Price: -


Row Count Plus Transformation allows you to select from a list of available variables and also also create new variables As the name suggests we have taken the concept of the stock Row Count Transform, recreated it and extended the functionality. The main enhancement is the addition of a new output, duration, which can be assigned to a variable in the same manner as row count. From a usability perspective, the stock transform uses the default editor, so clearly there is room for improvement. Unless you are always very well organised when designing packages you will have opened the stock transform and forgotten the name of the variable, or even forgotten to create it. The Row Count Plus interface will allow you to not only select from a list of available variables, but you can also create new variables to be selected there and then,...
- Platform: WinOther
- Row Number Transformation
- License: Freeware
- Price: -


The Row Number Transformation calculates a row number for each row, and adds this as a new output column to the data flow The Row Number Transformation will calculate a row number for each row, and adds this as a new output column to the data flow. The column number is a sequential number, based on a seed value. Each row receives the next number in the sequence, based on the defined increment value. The final row number can be stored in a variable for later analysis, and can be used as part of a process to validate the integrity of the data movement. The Row Number transform has a variety of uses, such as generating surrogate keys, or as the basis for a data partitioning scheme when combined with the Conditional Split transformation. Requirements:SQL Server 2005 Integration Services. SQLIS | SQL Server Integration Services - SSIS. SQL...
- Platform: WinOther
- Trash Destination
- License: Freeware
- Price: -


Trash Destination allows you to quickly terminate a data flow path The Trash Destination Adapter is a development aid. It will allows you to quickly terminate a data flow path, and does not require any configuration. It will consume the rows without any side effects, and prevents warnings or errors you may otherwise receive when executing the data flow. When building data flows you rarely complete them at the first attempt. By terminating the partially completed flow with the Trash Destination, you will not add any overhead to the processing, and it requires no configuration or external resources. You can then quickly add a Data Viewer to the path, and execute the package to check on your progress. For existing packages you may encounter problems, and wish to use an error output for row redirection where you would normally fail the...
- Platform: WinOther
