Bing Ads Source Component
The Bing Ads Source Component is an SSIS source component that can be used to read/retrieve data from Bing Ads services and produce column data which can then be consumed by a downstream SSIS pipeline component.
See Bing Ads Connection Manager for how to connect to a Bing Ads instance and see Bing Ads Destination component for how to write to Bing Ads.
The component includes the following two pages to configure reading data from Bing Ads.
- General
- Columns
General Page
The General page of the Bing Ads Source component allows you to specify the general settings of the component.
- Connection Manager
-
The Bing Ads Source Component requires a connection in order to connect to Bing Ads. The Connection Manager drop-down will show a list of all connection managers that are available in your current SSIS package.
- Bing Ads Service
-
The Bing Ads Services that are available for the instance will be shown in this field.
- Bing Ads Operation
-
The available operations on the service endpoint would be shown based on the previously selected service.
- Account Id (Available for Campaign Management service)
-
The Account Id can be specified in the field.
- Campaign Id (Available for Campaign Management service)
-
The required Campaign Id can be specified in the field.
- Ad Group Id (Available for Campaign Management service)
-
The required Ad Group Id can be specified in the field.
- Report Type (Available for Reporting Bing Ads Service)
-
The type of report to work with.
- Report Time Zone (Available for Reporting Bing Ads Service)
-
The time zone for the selected report.
- Report Date (Available for Reporting Bing Ads Service)
-
Choose the period you want to retrieve the data in. Alternatively, you can choose “Custom Dates” and specify the “Start” and “End” dates.
- Parameter Grid
-
- Input Parameter Name
-
The available input parameters for the endpoint would be displayed here.
Note: You can hover on top of the field to see if there are any special instructions for any given parameter.
- Type
-
The Type of the input parameter.
- Value
-
The Value to be sent as the input parameter can be either chosen from the default drop-down or specified in the field.
- Refresh Component Button
-
Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.
- Expression fx Icon
-
Click the blue fx icon to launch SSIS Expression Editor to enable dynamic updates of the property at run time.
- Generate Documentation Icon
- Click the Generate Documentation icon to generate a Word document that describes the component's metadata including relevant mapping, and so on.
Columns Page
The Columns page of the Bing Ads Source Component shows you all available fields from the endpoint that you service on the General page.
On the top left of the grid, the checkbox is used to toggle the selection of all available fields. This is a productive way to check or uncheck all available fields.
The Columns Page grid consists of:
- Bing Ads Field: Column that will be retrieved from Bing Ads.
- Data Type: The data type of this field.
Note: As a general best practice, you should only select the fields that are needed for the downstream pipeline components.