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
- SSIS
- Data Flow Task
- OLE DB Source
- As normal
- ADO Net Destination
- .Net Providers\SqlClient Data Provider
- Login