Back Up Smartsheet data to SQL Server through SSIS

Ready to get started?

Download for a free trial:

Download Now

Learn more:

Smartsheet ADO.NET Provider

Easy-to-use Smartsheet client enables .NET-based applications to easily consume Smartsheet Sheets, Contacts, Folders, Groups, Users, etc.

Easily back up data to SQL Server using the CData ADO.NET Provider for Smartsheet. This example uses an SSIS workflow to populate a database with Smartsheet data.

The CData ADO.NET Provider for Smartsheet connects Smartsheet data to applications that provide backup, reporting, full-text search, analytics, and more.

This example demonstrates how to use the provider for Smartsheet inside of a SQL Server SSIS workflow to directly transfer Smartsheet data into a Microsoft SQL Server database. The exact same procedure outlined below can be used with any CData ADO.NET Data Providers to connect SQL Server directly with remote data via SSIS.


  4. Add a new connection and select .NET Providers\CData ADO.NET Provider for Smartsheet.
  5. In the connection manager, enter the connection details for Smartsheet data.

    Smartsheet uses the OAuth authentication standard. To authenticate using OAuth, you will need to register an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties.

    However, for testing purposes you can instead use the Personal Access Token you get when you create an application; set this to the OAuthAccessToken connection property.

  6. Open the DataReader editor and set the following information:

    • Data access mode: Select 'SQL command'.

      SELECT TaskName, Progress FROM Sheet_Event_Plan_Budget


  9. Configure any properties you wish on the Mappings screen.
