I may have found the problem. The first record does not contain a full set of characters, and when I set up the fixed field column positions, I was not...

Sorry, I left 'DTSDestination("TTLCrd") = ' before the IF test. Let me get the proposed solution worked into the other transformations, and I'll check back.

Thanks again!

CSDunn

I applied the following, and I get a vbscript syntax error;

DTSDestination("TTLCrd") = If IsNumeric(DTSSource("Col004")) Then DTSDestination("TTLCrd") = CInt(DTSSource("Col004")) Else DTSDestination("TTLCrd") = 0 End If

Thank you for your response. I'll try this on Monday.

cdun2

Thanks!

CSDunn

That's it! Thanks!

CSDunn

Thanks. After some testing, I set the child packages to 'fail on first error'.

CSDunn

Never mind on this. I went with a global temp table.

Thanks.

CSDunn

Thanks for the response. I'm trying this from another angle, and I've run into some other problems. I'll post again shortly.

CSDunn

Thanks for your help!

CSDunn

Thanks for the input!

CSDunn

Thanks for your response. My first thought was to use MAX on all but the key fields in the Select statement on the source table, then group by the key...

Thank you for your help!

CSDunn

Again, never mind. The problem turned out to be a property of the workflow:

1) You may have the package option "Fail package on first error" checked.

Right-click on the designer...

Never mind on this, I've found a way to use SQL-DMO to fire XP_SendMail.

Thanks!

CSDunn