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?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…