I have created a SSIS package with a FTP task inside. The task uses the "Send File" feature and works in BIDS design mode.
The problem is when I use the package inside a SQL job - each time I get this error;
Message Executed as user: NT Service\SQLAgent$BI.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit
Copyright (C) Microsoft Corporation. All rights reserved.
Started: 22:12:29 Error: 2013-07-02 22:12:30.11
Code: 0xC002917B Source: PersonalFavorites_2013-06-25 FTP Task
Description: The File "PersonalShopper_Actions_20130625.csv" doesn't contain file path(s).
End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 22:12:29 Finished: 22:12:30 Elapsed: 0.936 seconds. The package execution failed. The step failed.
I have set the protectionlevel to "DontSave" and I have marked the job to be ran as 32 bit.
Thanks a lot for your help.
- Edited by RasmusEngel Tuesday, July 02, 2013 8:19 PM