Steve - I continued investigating and found the following tech note that resolved my problem:

FIX: SEM 7.0 Login Failed Message When Editing or Running DTS Package (Q247313)

In a nuthsell, it...

Steve - to answer your other question - I created an Execute SQL task with a simple SQL select statement and I received the same error when I attempt to...

Steve - Thanks for the reply. It is a Transfer SQL Server Objects task. It is set to transfer all objects. Under the options, I kept all...