How do you pass blob name as variable in Azure Blob Destination in SSIS just like passing tablename as variable in OLEDB destination?
In the control flow tab, click on the DataFlow Task, containing the Azure blob destination press F4 key to show the properties tab. Click on the expressions. You will find all Azure blob destination that can be passed as a variable.
Look at my answer in the following link it is a similar issue