Using the Source Component

After Establishing a Connection to the data source, you can use the RSSBus NetSuite source component in your Data Flow task. Follow the procedure below to connect to NetSuite, retrieve data, and provide data to other components in the workflow.

1. In the SSIS Toolbox, drag the RSSBus NetSuite source component into the Data Flow task.
2. Double-click the RSSBus NetSuite Source Component. The RSSBus NetSuite Source Editor will display. You can define connection properties in this dialog.
3. In the Connection Managers menu, select an available RSSBus NetSuite Connection Manager, or create a new instance if one is not already available.
4. Choose your Access Mode: "Table Or View" or "SQL Statement". Select "Table Or View" to use the GUI to select a table or view. Select "SQL Statement" to configure a statement of your choice.
5. Select the Columns tab and rename any output columns as desired.
6. Click OK to save changes. This will complete your source component configuration, and you will be ready to execute your data flow. When the data flow is executed, rows from your selected table or statement will be made available to the components in the data flow.

See SELECT Statements for the supported SQL syntax and examples.

See Calling Stored Procedures for how to call stored procedures.