General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Hi Sergey
look like the actual problem was a space in the path name.
Visual Studio and running the dtsx directly seemed not to have a problem with that but the Job agent did.
Separate question how would you find out what account the SQL Job Agent runs under.
.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only