Post reply

Fuzzy Grouping using MS Access as a Data Source

  • October 11, 2010 at 7:12 am

    #157248

    Using SQL Server 2005 Standard Edition SSIS 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.

  • October 12, 2010 at 5:44 am

    #1235416

    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."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply