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