Specifies the text file to use as the data source. This file location is relative to the SQL Server Database Engine specified ...

Specifies the text file to use as the data source. This file location is relative to the SQL Server Database Engine specified in the connection manager for this task. The text file must be accessible by the SQL Server Database Engine either on a local hard drive on the server, or via a share or mapped drive to the SQL Server. The file is not accessed by the SSIS Runtime.