Is there a problem with the KimbellMethodSCD and GUID Business Keys?

Nov 4, 2009 at 9:09 PM

I have GUID business keys and when I run all my data goes out the invalid path and I get the reason of "Invalid Business Key Fields" on all the records.

not sure what to do - any help would be appreciated.

Thanks

Nov 4, 2009 at 10:37 PM

yea, its wacked out. all my records were in both the source and the target already so I tried to delete a few records from my target table and those records did not get inserted. all of the records still go out the invalid path for the unknown reason above.

Looks like I am SOL. KimballMethodSCD does not work. using checksum for scd does not work and the SSIS SCD has the destructive wizard maintenance issues.

Anybody know how to do SCD stuff in SSIS? guess I will go with the SSIS SCD destructive wizard maintenance issues :(

Coordinator
Nov 9, 2009 at 9:33 PM

If the GUID BKs don't currently work for you, you may want to try converting them to string-typed columns.  Those will work.

I'll investigate the GUID BK issue and see if there's a problem.