Type the name of the destination table or view or select a table or view in the list.
Select the source of the format for the bulk insert. This property has the options listed in the following table.
Select a file containing the format specification. Selecting this option displays the dynamic option, FormatFile.
Specify the format. Selecting this option displays the dynamic options, RowDelimiter and ColumnDelimiter.
Select a File or Flat File connection manager in the list, or click <New connection...> to create a new connection.
The 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.
If you access the source file by using a Flat File connection manager, the Bulk Insert task does not use the format specified in the Flat File connection manager. Instead, the Bulk Insert task uses either the format specified in a format file or the values of the RowDelimiter and ColumnDelimiter properties of the task.