 |
ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check out our products including many FREE tools. If you are an MVP you may qualify for FREE MVP License |
SSIS Set Variable Transform (FREE)
SSIS Set Variable Transform (FREE) can be used to set variable inside SSIS Data Flow Task. This transform supports few modes such as Set, Increment, Append, Replace etc.
| This task is always FREE and will remain FREE after the trial period expires. All FREE tasks are packaged with with our complete offering in the 30-day trial installer. To access FREE tasks, simply download the trial installer. Please take a moment to check out the paid tasks while you have FREE access to our entire offering. Once the 30-day trial period expires, execution of the paid components will be disabled, but all of the FREE components will continue to work without interruption. These FREE components can always be used in production whereas the paid components will no longer work after the trial period without the purchase of a license. Enjoy! |
Features
- LoggingMode determines how much information is logged during Package Execution. Set Logging mode to Debugging for maximum log
- When you enable this property it will prefix timestamp before Log messages.
- Action you like to perform. If you set any action with ReplacePlaceholder then you must use placeholder where you like to insert upstream value. Use variable placeholder (e.g. {{User::MyVar}} ) if you wish to replace value from variable. Example for placeholder use: { tags : [] , Package: "{{System::PackageName}}" }
- Name of variable you want to set (e.g. User::vMyData)
- Number to add in previous variable value (This number can be -ve or +ve)
- Separator to use for Append mode (not valid for other mode). You can use \r\n for new line, \t for tab, \n for unix style new line.
- Separator to use for last row
- Support for SQL Server 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
Screenshots
 |
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...
|
Why SSIS PowerPack?
- Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
| |
