Bump.

Anyone interested in discussing this?

I've been doing some research...answered some questions. It looks like the KB link I have is probably to cumulative update 2 for SP2 (based on the filename being "Yukon_SP2_CU2"). ...

Not sure what the problem was. Restarted SQL services this evening and the memory allocation error has vanished. sp_send_dbmail can send attachments after the service restart.

It's...

I even tried reinstalling SQL and specifying the domain accounts during setup...the install then failed. Reinstalled with defaults and tried it pre SP1...same problem.

I'm really thinking it's SSL...just not...

Can't change it from SQL Server Configuration Manager. When I try I get: Cannot find object or property [0x80092004]

Got the answer to this, found a direct hit on the internet. It's a problem with trying to install from an extracted ISO image. Not sure if its...

Yes, I setup the AS400 as a linked server on our SQL 2005 box and pull and push data that way. The linked server definition will still allow you...

Thanks!

Thanks very much!

Now, any idea on how to get an actual result set into the body of an email? These would be simple result sets...like 3 rows...

Great, thanks. I thought the whole AWE issue was resolved with Server 2003...guess not. I did find info that said it would be on if my system had...

Just following up on this...hoping for some suggestions/info on the following:

- the convesion document is great but it doesn't say where to enter the conversion expressions in SSIS.  Everywhere I...

Thanks Jack.  I've tried manipulating the "externa'" and "Output/Input" columns in my source and destination objects within the Data Flow.  However, I always get an error.  I am probably doing something...

Quick update...  My problem appears to be in the conversion of DT_STR (on the SQL Server side) to DT_BYTES on the AS400.  I've searched on the issue but there is...

Yeah, I kinda figured I couldn't do it but I was hoping to hear differently from someone that knew better.  I think I'll probably just switch out the box with...

It services an internal web app accessible by all employees (which is enough to rule out per seat, etc.)