Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File location problem
Message
 
 
To
10/10/2011 05:24:51
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Miscellaneous
Thread ID:
01525943
Message ID:
01525958
Views:
42
What account SQL Server Agent runs under? Does it have permissions to the network drive in question?

>
>I have a package running to FTP some files to a local folder.
>
>I can run this package ok in Visual Studio Business Intelligence development studio and by running the dtsx package in SQL Server but when I save the package in SSIS store and run it from within SQL server as a job in Job Agent I get a failure.
>
>The error message is
>
> Source: Receive file from TB server FTP Task Description: Directory is not specified in the file connection manager "Local_file_location". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 09:43:46 Finished: 09:43:53 Elapsed: 6.937 seconds. The package execution failed. The step failed.
>
>
>Any thoughts. Is ther something else I need to do to run a dtsx package as a job.
>
>I think this must be a permission problem.
>
>The job runs ok in the Job Agent if I write to a local drive C:\temp but not if I write to a network drive. But both methods work if I run the dtsx package manually in SQL server.
>
>
>Thanks
>
>Nick
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform