• It doesn't show anything in log.

    Here it is

    Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 10:52:46 PM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 10:52:46 PM Finished: 10:52:56 PM Elapsed: 10.343 seconds.

    The package executed successfully. The step succeeded.,00:00:10,0,0,,,,0

    FYI, I am downloading file from FTP to a network storage drive. Do I need to give read write permission on NSD. If yes, then to which user account?