Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    5

    Unanswered: AS 2005 Slowly Changing Dimension - adding new rows when no change

    Hi , I am using the Integration Services slowly changing dimension to move data from a SQL Server 2000 database table to a SQL Server 2005 table.

    The other problem is the package is not tracking changes it is spending a lot of time doing lookups (it's slow), but ends up creating new records when there has not been a change.

    I'm quite sure the business key is set up correctly (I'm using the PK from the source table).

    The database I am transferring from has non Unicode data types (ie varchar and char) and the destination database has Unicode data types (ie nvarchar).

    Also some of the fields in the dB are NULL - does this have an effect (ie one null doesn't equal another null)? Or shouldn't that matter?

  2. #2
    Join Date
    Apr 2007
    Posts
    5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •