SQL 2008 R2 I have created an SSIS that I want to run via a Job. The package runs perfectly when ran manually. However when the job runs it I get an error. Message Executed as user: SQL1\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:44:02 AM Error: 2012-05-16 09:44:02.37 Code: 0xC001401E Source: CHRobinson Connection manager "Pipe File" Description: The file name "\\wsus\c$\FTP\CH Robinson\30420120516094402.txt" specified in the connection was not valid. End Error Error: 2012-05-16 09:44:02.37 Code: 0xC001401D Source: CHRobinson Description: Connection "Pipe File" failed validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:44:02 AM Finished: 9:44:02 AM Elapsed: 0.187 seconds. The package execution failed. The step failed. I believe the error is caused by permissions to access the folder on the remote computer. How would I fix this?

Sounds like the account the agent is running under does not have permissions to the \\wsus\c$ hidden share You should probabally have the admin set up an actual share rather than using the c$ hidden share - which generally requires admin priviledges to access. The SQL Agent will either need to be running under a domain account with permissions to that location or you will need to define a proxy for the SSIS job step that uses a domain account with access to that location. Chuck