Taking a close look to the execution progress indicate
[DST – SQL Azure ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 11.0” Hresult: 0x80004005 Description: “Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.”.
It is because all SQL Azure tables require a clustered index and we don’t have one for our new table. Now let’s go back to management portal and create a crusted index for the table.
Perfect I was able to execute the package the package and transfer around 350 thousand records from a local SQL Server to SQL Azure in about 2 minutes and 22 seconds with connection speed of 27.68 Mbps download and 5.6 Mbps upload speed.
Downloading data from SQL Azure could be done with the same way by converting the source and destination.