Top Posts & Pages
- MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
- Dynamic Column Mapping in SSIS : Part 1
- Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
- Restore SQL Server database using SAS from Azure Blob Storage
- Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
-
Recent Posts
Categories
Tag Archives: Script task
Access SSIS variables in script task and script component
You have to write codes to access the variables in these two components in a slight different way. For Script Task: DTS.Variables[“VariableName”].Value For Script Component: Variables.VariableName Don’t forget to add these variables in task editor first. 🙂