none
ADF Copy Data Launch - Migrating data from Excel/CSV to Azure SQL DB

    Question

  • Hi All,

    I have the below requirement:

    I need to migrate data from a source to Azure SQL DB.

    Source: Csv file. Number of sheets = Number of entities. Number of columns in sheet = Fields in respective entities. I need to migrate data from Source to Azure SQL DB. Source is on my local system.

    I tried to used to Copy Data Launch wizard keeping Source connector as File System. However, in that scenario, I am unable to install the gateway. 

    Please suggest me how do I proceed.

    Regards,

    Rameshwari



    Friday, April 21, 2017 2:14 PM

All replies

  • Hello,

    You can also put those CSV files on a BLOB storage and upload their content to a SQL Azure Database as shown below.

    BULK INSERT Test

    FROM 'source/data/Test.csv'

    WITH ( DATA_SOURCE = 'MyAzureBlobStorage',

                  FORMAT='CSV', CODEPAGE = 65001,

                  FIRSTROW=2,

                  TABLOCK);


    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, April 21, 2017 3:40 PM