We are in the process of migrating from SQL 2k to 2008 R2. Currently, we have hundreds of jobs and dts packages that exec xp_sendmail. I have successfully made a copy of a dts package and altered it to use dbmail, used Migration Wizard to move the package, and used the Transfer Jobs task in an SSIS package to move the corresponding job. My problem is that all of our hundreds of email contacts exist in Outlook. Since MAPI is now out in 2008, where do our contacts live? The job will successfully execute the migrated DTS packages and send the email if I change the recipient from a contact name to its explicit email address. I will already be doing a ton of editing to change xp_sendmail to dbmail, and also change some of the parameters. But I'd prefer not to have to change the contact names to email addresses if there is a way around it.
Thanks