Using the Microsoft SQL Server BCP Import Wizard

By using the Microsoft SQL Server BCP Import Wizard, you define the web service object you are integrating based on the action you specified.

Procedure

1. Create or open a Microsoft SQL Server BCP Operation component.

2. In the Connector Action field select either Create or Query.

3. Click the Import button.

   The Microsoft SQL Server BCP Import Wizard opens.

4. In the Browse In field, select Cloud or Runtime.

   You can run this connector on a basic runtime. You cannot run this connector in a runtime cloud. You also can run it in your private runtime cloud if high security is off or if you added additional permissions to it.

5. Optional: If you selected basic runtime, select a runtime from the list.

6. Select a Microsoft SQL Server BCP Connection component and click Next.

7. Enter a table pattern.

8. Select Include Tables and/or Include Views.

   No data is returned if neither check box is checked.

9. Click Next.

10. Select an object type.

    The list of available objects depends entirely on the SQL Server database target.

11. Click Next.

12. Review the results and click Finish.