One of the questions that I always hear in the forums is about moving data in and out of a SQL Azure database. People who intend to move their existing applications to SQL Azure need to find a way to load their existing data into SQL Azure databases. Since the current version of SQL Azure does not support database backups, they might also need a way to pull the data out of a SQL Azure database and mimic a regular backup.
In this article, Siddharth Mehta explains how to read and write data from SQL Azure using SSIS.
Read the article: http://www.mssqltips.com/tip.asp?tip=1937