Heya John and Luis,

Thanks to you both for your input and ideas for improving what I had. It does seem to me, as Luis mentions, that I will need to...

Hi Luis,

Thanks for responding but similar to John's solution, since this is using the RootRunLogID, it doesn't allow me to filter on other RunLogs 5 thru 12, which...

Heya John,

Thanks for the quick response. I have to take back my last statement...

If I could include the Root RunLogID value in the final result I could filter on it...

Thanks to all for great advice and the pointers to various tools.

Cheers,

Steve

Thanks again Eirikur.

I am currently using TortoiseSVN for all application related files but am still really in development mode, though some people are doing alpha testing for me.

I would...

Hi Eirikur

This would be considered small compared the the databases I am use to working on but here are counts from sys.objects

User Defined Tables: 54

Views: 46

Stored Procedures: 77

It...

In doing some experimenting un-checking 'Keep Nulls' gives me what i need if the field is NULLable as John mentioned. The problem is the field isn't, i.e. it should never...

Sorry, again not being clear.

By DEFAULT I meant the default value declaration for the column. Wouldn't it just be handled by the trigger? In otherwords could I just have... ...

Hi Eirikur

Unfortunately I have no control over the data structure so is not be an option for me.

Interesting idea though. Quick followup, if I had that as a trigger, would...

Thanks again John

I included the insert because I have been asked in the past to provide the data structures/processes. My bad for leaving out that I was using OLEDB Destination...

Hi John,

Thanks for the response.

Sorry for being dense but how would I assign a value of DEFAULT? I probably should have been more clear, I am using OLE...

Heya John,

No I hadn't, I tend to forget about the Advanced Editor options.

Thanks very much

Steve

@john-2 - thanks for your suggestion but I try to avoid using staging tables when I can.

@phil - Sounds like a good suggestions, I will definitely give...

Hi John thanks for the response.

The following is made up structures and data:

-- table of products

CREATE TABLE xyzProducts (pkProducts INT NOT NULL ,ProductName VARCHAR(20) NOT NULL ...

Thanks Thom A,

I just wanted to make sure that I wasn't missing something. My SSIS solutions works just fine, though I am sure some SSIS developers would have a fit...