Run a Job on SQL Azure (Using SSIS Package)
Requirements : A valid azure account, Local Instance of SQL Server (>= 2012), SQL Server Data Tools, Excel 2007 or above Scenario : Dump Excel File Contents to a Table in SQL Azure Steps : Develop SSIS Package- Drag Data Flow Task on the control flow window and double click on it to open the Data flow window Drag Excel source and configure it to the source file and the worksheet. Drag ADO.NET Destination. Create a new ADO.NET connection by selecting provider - .NetProviders\SQLClient Data Provider Put in the server name of a valid SQL Azure database. User SQL Server Authentication and type in the username and password. Go to ALL window and set the properties Select the target database. Configure ADO.NET destination with this new connection manager. Point to the target table. Map the columns correctly. Save the package by specifying the password (using encryptsensitivewithpassword) Go to ProjectProperties --> Debugging and set the Run64bitruntime propert