Products

Pragmatic Works uses has used its unique experience with client issues to create a series of products to help you develop enterprise-class business intelligence solutions with a small company price point. Whether you're trying to speed your SSIS development up with new enhanced SSIS components or if you need help with DTS conversions, Pragmatic Works has a solution for you. You can also contact us to develop a custom solution for you.


DTS xChange


The built-in wizard to migrate DTS packages is approximately 40% successful and does not allow you to enjoy the benefits and best practices of SQL Server 2005 Integration Services (SSIS). DTS xChange is a product to help you migrate from SQL Server 2000 DTS to SSIS. It does this by applying a series of rules and best practices to your old DTS packages as it migrates the packages. 

More Information about DTS xChange

 

 

SSIS xPress


Manage SSIS right from the start. SSIS xPress applies rules and best practices across all of your SSIS packages allowing for easy, deployments, auditing, monitoring, and reporting on SSIS

More Information about SSIS xPress

 

 

 

File Properties Task

File Properties TaskThe File Properties SSIS Task reads the properties of a file and writes the values to a series of variables. For example, you can use this task to determine if the file is in use (still be uploaded or written to) and then conditionally run the Data Flow task to load the file if it's not being used. You can also use it to determine when the file was created in order to determine if it must be archived.

More Information about the File Properties Task



Terminator Destination

The Terminator Destination allows you to terminate a data flow into a dead end. It acts as a stub for other code that you may eventually write once you receive the business requirements. As it receives data, it simply disposes of the data and you can ideally put a data viewer on it to test.

This free SSIS component is supported through the forums only and is distributed *as is*.

Download The Terminator Destination

 

Upsert Destination

The Upsert Destination is an SSIS component that will conditionally insert, update or delete data from a destination based on if the data is on the destination or not. If you're interested in participating in a beta of this production, please contact beta@pragmaticworks.com.

Available December 2007

 

Copyright ® 2007 Pragmatic Works