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