Posted by David Portas on 03/14/06 18:26

jim_geissman@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/issues/05/09/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/integration/datastage/

SSIS home:
http://www.microsoft.com/sql/technologies/integration/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/ms130214(en-US,SQL.90).aspx
--

[Back to original message]