Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Titre:
File location problem
Hi
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement