Perfect. Thank you.

I actually logged in today to ask just about the same question. I would also like to know how this can be done. The sp_helprotect will provide a...

Just to close this topic (for now), I really appreciate the assistance provided and it has helped me greatly. After some of the suggestions and additional reading, it appears...

I tried using dtexec for execution, but there was no improvement.

Thanks,

I do use the redirect of the fundamental row key information in the package (rather than the default error). I then add the package and task using audit and...

Thank you for your help. I tried the code you sent (made the change back to my environment) and got the same information. Some looking around and there...

I have tried including the database reference with the same results:

"Msg 22050, Level 16, State 1, Line 0

Error executing extended stored procedure: Invalid Parameter"

I can send a test message successfully,...

I tried the suggested change (modified the recipient to myself and the profile to our installed profile) with the same results.

After that, I tried exactly as you sent it hoping...

Yes. There are other SSIS packages that run independently and as part of scheduled jobs. However, this is the only (first) one that attempts to import a worksheet...