KingswaySoft
SSIS
Productivity Pack
Premium SSIS components to increase productivity and facilitate advanced integrations
Premium Collection
A premium collection of SSIS component add-ons developers will use every day to increase their SSIS productivity.
No Custom Scripts
Over 300 premium and unique SSIS components to facilitate rapid ETL development without any custom scripting.
Expand Native SSIS
Premium SSIS components expand on native SSIS components to offer new features with improved performance and greater ease of use.
Save Time
The SSIS Productivity Pack saves time and offers significantly greater potentials when implementing solutions using SSIS.
Familiar Technology
Built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have.
Incredible Features
The SSIS Productivity Pack is a gold mine of features that allows for powerful data transformation in one easy-to-use component.
EDI Source and Destination
Extract data from EDI documents to use in downstream pipeline and easily write to EDI files.
Support for over 100 APIs in the REST framework
Auth0, Bill.com, ClickUp, Discord, Drift, Expensify, Google Forms, Jotform, Mailjet, Okta, PowerBI, PrestaShop, ShipStation, and more
What Our Clients Have to Say About the SSIS Productivity Pack
Testimonials
"The Premium Derived Column component in the SSIS Productivity Pack was a gold mine of features that allowed for powerful data transformation in one easy to use component."
Winson Group"Getting the SSIS Productivity Pack enabled us to build connections to numerous API's in a timely fashion."
Weiss Research, Inc.What Our Clients Have to Say
About the SSIS Productivity Pack
Testimonials
"The Premium Derived Column component in the SSIS Productivity Pack was a gold mine of features that allowed for powerful data transformation in one easy to use component."
"Getting the SSIS Productivity Pack enabled us to build connections to numerous API's in a timely fashion."
The SSIS Productivity Pack is a collection of premium SSIS components to enable greater developer productivity and increase the power of SSIS.
Here are just some of the more than 300 components you will find in the SSIS Productivity Pack.
JSON & XML Processing
Bring data from JSON or XML documents into SSIS easily with source or extract components.
Data Anonymizer
Keep sensitive data in production, anonymize data before bringing into UAT environments.
Premium Excel
Work with Excel data in both 32 and 64-bit runtimes.
Premium Derived Column
Unleash the full power of SSIS expression utilizing the Premium Derived Column component.
Data Spawner
Quickly and efficiently generate sample data for testing.
Address Verification
Perform address verification in a batch fashion.
Premium Slowly Changing Dimension
Development for Slowly Changing Dimensions cannot be any easier.
Premium ADO.NET
Go beyond Insert - Update, Delete or Upsert to databases with Premium ADO.NET Destination.
Duplicate Detector
Identify and detect duplicates from upstream source system using many configurable duplicate matching algorithms.
Diff Detector
Compare data from two sources with the Diff Detector to find any differences between rows.
NoSQL
Work with NoSQL data as if it were column data.
Premium Lookup
Perform lookups with any data input as the lookup source without limitation.
Premium OData
Read or write to an OData instance endpoints without effort.
PGP Encryption
Encrypt and decrypt files from within the SSIS control flow.
Messaging Queue
Easily connect and integrate with various message queue services without writing a line of code.
Google Services
Quickly retrieve Google Ads and Analytics data.
FTPS/SFTP
Connect to FTPS or SFTP servers easily within SSIS.
Timer Task
Throttle package execution using the easy-to-use Timer Task.
SMTP
Set up automatic SSIS job execution summary email notification with ease using the SMTP task.
Compression Task
Compress files with the powerful Compression Task.
Retrieve emails from a POP3, IMAP, or Exchange server and output them to columns.
Template Merge
Perform text or HTML content merge with SSIS columns/variables with an easy-to-use UI.
EDI Source & Destination
Extract data from EDI documents to use in downstream pipeline and easily write to EDI files.
Time Zone Conversion
Easily convert a date column from one timezone to another.
Our complete list of components all available within the SSIS Productivity Pack.
0
Connectors
Premium ADO.NET
Premium Aggregate
Premium Conversion
Premium Derived Column
Premium File Watcher Task
Premium Excel
Premium Lookup
Premium OData
Premium PDF Source
Premium Service Lookup
Premium Slowly Changing Dimension
Premium Expression Task
Premium File Properties Task
Windows Command Task
Data Anonymizer
Data Spawner
Address Parser
Address Verification
Data Profiler
Diff Detector
Duplicate Detector
Compression Task
PGP Encryption Task
Premium Hash
Amazon DynamoDB
Amazon Redshift
Avro
Azure Table
Cassandra
CDM
Cosmos DB
Couchbase
EDI
Elasticsearch
Google BigQuery
Hadoop
HDFS
HL7 Support
MongoDB
ORC
Parquet
PostgreSQL
Power BI
Premium Data File
Redis
Salesforce Einstein Analytics
Snowflake
Tableau Hyper
Amazon S3
Azure Blob Storage
Azure Data Lake
Azure Files
Azure Queue Storage
Box
CSV
Dropbox
Google AlloyDB
Google Cloud SQL
Google Cloud Storage
Google Drive
Microsoft OneDrive
FTP Connection Manager
FTPS Connection Manager
SFTP Connection Manager
SMB Connection Manager
Premium File System
Premium File Transfer Task
Premium Flat File
WebDAV
ActiveMQ
Amazon SQS
AMQP
Azure Service Bus
IMB MQ/WebSphere MQ
Kafka
MSMQ
Premium Message Queue Task
RabbitMQ
SMPP
SMTP
HTML Merge
Text Merge
JSON
XML
HTML Table Source
Azure Functions
SSH Task
Time Zone Conversion
Timer Task
Composition
Decomposition
Value Mapping
Bing Ads
Google Ads
Google Analytics
Google Search Console
Google Tag Manager
Google Sheets
YouTube Analytics
AS2 Connections
GraphQL
Google People
HTTP
Web Service
Acumatica
Airtable
ADP
Asana
Azure Application Insights
Act-On
ActiveCampaign
Auth0
Authorize.net
BambooHR
Basecamp
BigCommerce
Bill.com
Blackbaud
Calendly
Ceridian Dayforce
Chargebee
Chargify
ClickUp
Constant Contact
Copper
DocuSign
Discord
Drift
Duo Security
Dynamics 365 Customer Insights
eBay
Emarsys
Emfluence
Expensify
Eventbrite
Google Classroom
Insightly
Facebook Business
Facebook Messenger
FreshBooks
Freshdesk
Freshsales
Freshservice
GitHub
Google Calendar
Google Maps
GoToWebinar
HubSpot
Jira
JotForm
Keap (InfusionSoft)
LinkedIn Business
Magento
Mailchimp
Mailgun
Mailjet
Marketo
Microsoft Teams
Microsoft To Do
MYOB
OneLogin
Okta
Open Accounting
Paycor
PayPal
Ping Identity
Pipedrive
Prestashop
Quickbase
QuickBooks
RingCentral
Sage Business Cloud
Salesforce Marketing Cloud
Salesforce Pardot
SendGrid
Sendinblue
Snapchat Business
ServiceNow
ShipStation
Shopify
Slack
Smartsheet
Square
Stripe
SurveyMonkey
SugarCRM
SuiteCRM
Teamwork
Trello
TikTok Business
Twilio
Twitter Business
Typeform
WordPress
WooCommerce
Xero
Yammer
Zendesk
Zoho Books
Zoho CRM
Zoho Desk
Zoho Expense
Zoho Invoice
Zoho Sheet
Zoom
Zuora
Easily Solve Your Data Integration
and Migration Problems
With the SSIS Productivity Pack, developers can get their job done quicker using some of the most advanced ETL components in the industry.
Technical Requirements: The SSIS Productivity Pack requires SQL Server Integration Services, we support deployments to Azure-SSIS Integration Runtime (ADFv2) or Microsoft SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, and 2008.