Using SSIS to import data from SQL Server on premises to SQL Azure

20-Feb-1212 Leave a comment

This assumes prior knowledge of SSIS, but just hi-lights the difference

  1. SSIS
  2. Data Flow Task
  3. OLE DB Source
    1. As normal
  4. ADO Net Destination
      1. .Net Providers\SqlClient Data Provider
      2. Login

Filed under SQL Azure, SQL SSIS

Leave a comment