Software Listing of Author : "Sqlis.com"

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 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 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 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 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

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 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
New Reviews

Print Inspector

Whether you are using a printer connected to your local desktop computer or a print server sometimes you need to see whats going on in your printer by having a close look at the print jobs sent by the users. Print Inspector is such type software ...


Disk Genius

Disk Genius was formerly known as Partition Guru which is an all-in-one solution for disk partition management, data recovery and disk repairing. It can recover lost files from partition, backup and restore partition table, clone partition or clone ...


Safe In Cloud

It is quite difficult to find any computer users nowadays who do not need to use the web, for any purpose. Whether it is for education or entertainment, the web is your best resource. You also need to use various online services for banking, ...


PictBear

Nowadays, a majority of PC users resort to digital image editing once in a while. It may be required for retouching image captured in smart phones or for creating an album in Facebook. For some people, tinkering with digital images is a pastime too. ...


Panda Cloud Cleaner

PC security has become a tricky and complicated subject both for home users and network supervisors, with complexity and risk factors multiplying over the years. Using a single antivirus app may not be enough anymore. That explains why many users ...


SnapCrab

Nearly every PC users need to take screenshots from time to time, whether it is for personal or professional needs. While using the basic Windows screenshot capture method is available, it is not adequate for everyone. When you want to capture ...


BitKiller

Dealing with various types of data efficiently holds the key to success in any computing task. Apart from generating new data and modifying existing files, it becomes necessary to delete existing files at times. While most users resort to using ...


New Downloads

@SwIt Printfil

Print from DOS, Unix, Linux to
Windows printers: USB, GDI,
PDF, e-mail, network, IP, fax.
Capture LPT1:-LPT9: & ...

Disk Usage Analyzer Free

Disk Usage Analyzer Free - a
small utility that will help
you visualize how to allocate
space on your hard drive. Any
PC ...

RationalPlan Single Project

RationalPlan Single Project is
a project management software
covering the project
management areas starting with
WBS ...

DreamPlan Home Edition

DreamPlan Home Edition for
Windows is an easy to use
software. See your dream floor
plan with customized kitchens,
...

Express Burn Plus for Mac

Express Burn Plus for Mac is
an ultra fast burner to help
save you time. Burn audio,
video, or files to CD, DVD.
Express ...

Express Zip Plus for Mac

Express Zip Mac Software for
File Compression and
Archiving. Easily create,
edit, manage and extract
compressed files and ...

Devart ODBC Driver for
Oracle

Devart ODBC Driver for Oracle
is a high-performance
connectivity solution with
enterprise-level features for
accessing ...

FTP Manager Lite

Free fast FTP client supports
secure transfers and multiple
connections. The file manager
like interface is intuitive to
...

Lodgit Desk Hotel Software
for Windows

Booking software for all kinds
of lodging establishments
incl. reservation schedule,
booking and guest list,
cleaning ...

Database Workbench Pro

Cross database engine
developer IDE for PostgreSQL,
InterBase, SQL Server,
Firebird, MySQL, Oracle,
NexusDB, MSDE and ...