<div>
I found that I CAN &nbsp;manually run the task by selecting the task at the File System store and then selecting run. (I.E. using dtexec). It still will not run as a job.
</div>


I found that I CAN  manually run the task by selecting the task at the File System store and then selecting run. (I.E. using dtexec). It still will not run as a job.

<div>
<div class="content wysiwyg-content">
This is a follow-up to the following thread:<br />
<a href="https://www.experts-exchange.com/questions/23152990/SSIS-Access-to-the-path-is-denied-error.html" rel="ugc">https://www.experts-exchange.com/questions/23152990/SSIS-Access-to-the-path-is-denied-error.html</a><br />
<br />
I have created a credential and proxy. I then created a job with the one step being to run a specific SSIS task. On this step, I assigned the proxy I created as who the task should run as. I ensured that the account that was used has full control over the destination folder that the task will be accessing. I also gave the account the sysadmin role in the SQL Server database. The task fails when I tell it to run. The task failure refers me to the History log which contains nothing that helps me determine why it fails.<br />
<br />
The task runs fine through BIDS. When I try and run it manually from the SQL Server using dtexec it fails with a &quot;unable to access folder&quot; error at the first file system task. This is why I am trying to run it using the SQL Server agent.
</div>
</div>


This is a follow-up to the following thread:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23152990.html

I have created a credential and proxy. I then created a job with the one step being to run a specific SSIS task. On this step, I assigned the proxy I created as who the task should run as. I ensured that the account that was used has full control over the destination folder that the task will be accessing. I also gave the account the sysadmin role in the SQL Server database. The task fails when I tell it to run. The task failure refers me to the History log which contains nothing that helps me determine why it fails.

The task runs fine through BIDS. When I try and run it manually from the SQL Server using dtexec it fails with a "unable to access folder" error at the first file system task. This is why I am trying to run it using the SQL Server agent.

Unable to run task in SSIS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.