Hello Experts Exchange
I have two SSIS packages, when I run them in BIDs they run fine and data is updated, when I schedule them to run in SQL Agent the jobs report Succeeded but not data has changed.
There is three steps in the SSIS package.
1) Copy Access file from server to local server. (Execute Process Task)
2) Truncate Table. (Execute T-SQL Statement Task)
3) Import data from Access DB in to SQL. (Data Flow Task)
I am using SQL Server 2012, on Windows 2008.
Has anyone seen this problem before? How do I get SQL Agent to work?