The Bulk load into Azure SQL DB entry includes four tabs to define the data input source, the output database and location, options, and advanced options for loading PDI data into an Azure SQL database. Each tab is described below.
|Source||Specify the VFS URL of the data to import. The URL can point to a file or a folder in Azure Data Lake Storage. The URL must begin with |
|What file type is your source?||Select the file type of the input source. Must be a CSV file.|
Delimited text settings
Specify the following settings for a delimited text file:
Select your database connection from a list of existing Azure SQL DB connections.
If you do not have an existing connection, click New. If you need to modify an existing connection, click Edit.
|Schema||Select the schema to use for the bulk load. The Bulk load into Azure SQL DB entry reads the schemas that exist in the database to populate this list.|
|Table name||Select the name of the table to bulk load. The Bulk load into Azure SQL DB entry reads the table names from your selected schema to populate this list.|
|Columns||Preview of the column names and associated data types within your selected table.|
|Truncate table||Select to remove all the data in the table before bulk loading the current data. Clear to append data during a new data load (default).|
Advanced options tab
Specify whether to force loading of files into a database: