Brian -

Sorry for the long pause, but thanks, that was the trick! I'm breaking it down now to 'burn -in' the logic.

Yes. There may be skips (1,2,3,5,6,7,11,12,13), but they are unique, ascending.

You can save as a basic file and mark up the .bas file in document editor. Not so automated, but gets you part way there.

Gosta;

Are you saying you use the Excel automation object in an ActiveX task to populate the ranges from code, rather the data transform task itself?

Randy.

Actually there is always a type = 'H' (default) in table 'B' as long as the code exists. The problem is if there is a match on another type, use...

Thanks, I was going down that 2nd alias road when I realized that I also had to join on tblB. Now it's gets a bit confusing. That tblB has to...

Sorry, brain fart. Forgot I was in reporting services and not DTS.

Just comming on RS myself. Can you run script to set the report parameter prior calling the report or...

What I (and I think AJ) were thinking is you would set the data prior to running the report. Your report would report on data where the 'bit' field was...

I think AJ has it. Use the current day to determine which unset 'bits' get set. If day of month is less than 10, then set unset bits previous to last...

Actually, It's a transformation task issue.

If I loop thru and reset the DBF connection file name, the initial column transformation needs to be reset in the transormation task. For each loop...

After running into same scenario (insert only) I went to a DDQT (Data Driven Query Task). Then after finding I needed an identifier on each record to determine insert/update, which...