Menu
How do you pass blob name as variable in Azure Blob Destination in SSIS just like passing tablename as variable in OLEDB destination?
472
The Azure Storage connection manager enables a SQL Server Integration Services (SSIS) package to connect to an Azure Storage account. The connection manager is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure. In the Add SSIS Connection Manager dialog box, select AzureStorage > Add.
With Azure-SSIS IR, you can easily run the SSIS packages that are deployed into the SSIS catalog database, hosted in an Azure SQL Database server or an Azure SQL Database Managed Instance using the Project deployment model, or run the packages that are deployed into the file system, Azure Files, or SQL Server MSDB ...
You can now move your SQL Server Integration Services (SSIS) projects, packages, and workloads to the Azure cloud. Deploy, run, and manage SSIS projects and packages in the SSIS Catalog (SSISDB) on Azure SQL Database or SQL Managed Instance with familiar tools such as SQL Server Management Studio (SSMS).
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
SSIS: Dynamic Lookup Query
95
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
