SQL Server 2005 vs Ascential

[jim_geissman]

Can anyone please point me to a study comparing SQL 2005's integration
services with Ascential, specifically for the tasks of (a) matching
records about residential properties and transactions (typically
described in terms of address, owner name, parcel number and legal
description -- which may not be accurate or complete; a given
transaction may appear in several feeds), and (b) creating composite
records from matched sets. In Ascential, (a) is called "Quality Stage"
and (b) "Data Stage".

Thanks,
Jim Geissman

[David Portas]

ji**********@countrywide.com wrote:

Can anyone please point me to a study comparing SQL 2005's integration
services with Ascential, specifically for the tasks of (a) matching
records about residential properties and transactions (typically
described in terms of address, owner name, parcel number and legal
description -- which may not be accurate or complete; a given
transaction may appear in several feeds), and (b) creating composite
records from matched sets. In Ascential, (a) is called "Quality Stage"
and (b) "Data Stage".

Thanks,
Jim Geissman

Haven't seen any specific comparisons. This article may be relevant:
http://msdn.microsoft.com/msdnmag/is...SQLServer2005/

Note that Ascential is no longer Ascential. DataStage is now part of
IBM's WebSphere line-up:
http://www-306.ibm.com/software/data...ion/datastage/

SSIS home:
http://www.microsoft.com/sql/technol...n/default.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--