Analytics in Action

Using SQL Server Integration Services (SSIS) to load a SQL Azure table

Sep 18th in Data Integration by admin

1

SQL Server Integration Services (SSIS) can be used to load data into the a cloud based database like Microsoft SQL Azure. It involves 5 basic steps : 1) Create SQL Azure account, database & destination table .2) In SSIS create a connection to the source data.3) Ensure the source & destination data types are the same.4) Identify your “Fully Qualified DNS Name” and destination Table name in SQL Azure .5) Create an ADO.NET connection to SQL Server Azure.

Related posts:

  1. Creating & populating a Table in SQL Server using the SSIS Import & Export Wizard
  2. Introduction to the Basics of SQL Server Integration Services (SSIS)
  3. How to create a basic SQL Server Reporting Services project with drill down functionality using the Report Wizard.
  4. How to build a SQL Server Integration Services package.
  5. Setting up a Lookup Transformation in SQL Server Integration Services (SSIS)
« »

admin

One Response to “Using SQL Server Integration Services (SSIS) to load a SQL Azure table”

  1. Aishya
    Dec 19th

    Awesome tutorial!! Very very useful and helpful. Thanks a lot.

    Reply