• hsmanandhar 33101 (2/21/2013)


    I solved my issue.

    Steps I made for Job run successful :

    Create a Credential in SQL Server with the windows User Name.

    Create Proxy with this Credential.

    Run SSIS with Proxy.

    This solved my issue and now generate encrypted file with SQL Server Job.

    Thank you all who have help me a lot.

    That sounds about right. What is the SQL Server Agent service account and what account did you use as the proxy?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato