Fuzzy Grouping using MS Access as a data source

[cs2009]

Using SSIS 2005 and MS Access 2000.

Is it possible to use MS Access 2000 as a data source and destination for Fuzzy Grouping?

I've tried using a connection manager of type Native OLE DB\MS Jet 4.0 OLE Db provider with a OLE DB source and get an error message stating, "The DBMS type or version of runtime connection OleDbConnection is not supported".

I also tried using a connection manager of type ADO.net ODBC data provider with a Data Reader source and get the same error message.

Does someone have detailed, step-by-step instructions for using MS Access 2000 as a data source and destination for a fuzzy grouping transformation?

Thanks.

 

[cs2009]

I found this in BOL:

"The transformation (Fuzzy Grouping) requires a connection to an instance of SQL Server 2005 to create the temporary SQL Server tables that the transformation algorithm requires to do its work. The connection must resolve to a user who has permission to create tables in the database.