when I run the package from the command line. (Actually, when I choose "start without debugging" in VS

I am not real clear on your requirements, but if what you need to do is insert a record if it does not exist in the table, and update otherwise...

oops sorry - gave some misinformation below. CheckSum transformation is NOT native to VS/BI 2005 (SCD transformation is). You can DL CheckSum from http://www.sqlis.com/post/Checksum-Transformation.aspx

That's exactly what I want to do, tag all the records loaded with the same date stamp so I can identify them by batch. Thanks again - I can...

John,

I tried the SCD transformation and found that it is very similar to CheckSum except for the wizard and the fact that no extra hash column is added to DB...

ya, CRC32 was identifying every record following a changed record as having a new CheckSum value and therefore causing lots of duplicate records to be inserted. Switching to the...

I didn't know about the SCD Transformation. I've got to get out more. I was however, able to get the CheckSum Transformation to accomplish the same thing, check...

John,

First of all I really do appreciate you taking the time to help me, a perfect stranger (well maybe I'm not that perfect 🙂

Anyhow - you have successfully answered my...

No, by "rules" I mean the criteria used to determine if data is valid or not, so I guess they are code-driven? I worked with a Rules Validation Engine...

Thanks so much for responding, John. Here are the answers to your questions:

Can you give me an example of what kind of validations you are trying to do?

1) Most...

I remember a co-worker had this exact same problem a few years ago. Sorry to say as far as I know it was never resolved! You asked for...