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 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

The General page of Bing Ads Source component allows you to specify the general settings of the component.

SSIS Bing Ads Source

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 the 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 update of the property at run time.

Generate Documentation Icon
Click the Generate Documentation icon to generate a Word document which describes the component's metadata including relevant mapping, and so on.

Columns

The Columns page of the Bing Ads Source Component shows you all available fields from the endpoint that you service on the General page.

SSIS Bing Ads Source - Columns

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.