• I am able to run the SSIS package just fine by itself, and I am using my sql account. The issue happens when I add it to the SQL server agent to execute, that's when my package fails.

    Any thoughts?

    amirhh2000 (3/24/2014)


    First of all I hate SSIS2005 ... it has too many bugs ... (preferably use 2008R2 or 2012)

    Things you can check are as follows:

    1. Make 64bit false

    2. Delay validation = False (in the body of package and on all objects)

    3. EncreptionMethod = SensitiveWithPassword

    4. If you changed number 3 reopen your data connections and re enter username password to be encrypted with the new method.

    5. SQL Agent Service account has access to your Excel/Access datafile location

    6. Create the SQL Job from SSMS2005 not SSMS2008/2012

    7. be patient ... 🙂

    Cheers

    Amir