Use a Copy Data activity with SQL Server as the source and Blob Storage as the destination, without any partitioning.

Use a Lookup activity to retrieve the partition keys, followed by a ForEach activity to iterate over the partitions and a Copy Data activity to transfer each partition.

Use a single Copy Data activity with SQL Server as the source and Blob Storage as the destination, and configure the sink to partition the data by date.

Use a Web activity to trigger an external script that partitions the data before copying it to Blob Storage.