I've implemented the Anatomy of Incremental load the same was as it was illustrated. The package was working for 2 months.

The ETL SSIS package that loads a dimension...

Hi Andy,

Thanks for the quick response.

In the lookup, I am matching all of the columns in the composite key. However, in the conditional split for New Inserts I wasn't sure...

Hi Andy,

Following your approach for incremental load; in the conditional split for New Inserts, if I have a composite key column, which of the following is the correct way:

"&&"...

Hi Andy,

I implemented the incremental load the same way as you illustrated. It is working, but I was told to add an exception table for duplicate records.

How would you...

Dear Mr. Leonard,

I followed your example "Anatomy of an Incremental Load" and came across a few questions.

I followed all of your recommedation and did everything you said. With two...

If you create the two tables I included and insert the two rows and then run the script you should be getting this data. I am trying to write a...

Michael,

Thanks for all your help. Really appreciate it.

Going back to the same question for updating the log / history table in the Control flow.

So you recommended that I should use...

Going back to the original problem, where the the Set Package Path (script task) and execute package task did not recognize the packageName. Now it works fine because I have...

Thanks for your imput. It worked well.

I went ahead and setup the logging in my SSIS package. It seems to work pretty well.

Other than that, all the tasks...

Michael,

I actually forgot to include the .dtsx extention in PackageName. I added it and its working just fine.

Now, I have another question. I have an audit table called tblimportLog with...