Loading table of contents...
Welcome
Release notes
System Requirements and Installation
Getting Started - Using SSIS PowerPack
End User License Agreement - EULA
Contact us
Tasks
Advanced File System Task
Advanced SSIS File System Task
Amazon DynamoDB ExecuteSQL Task
SSIS Amazon DynamoDB ExecuteSQL Task
Amazon Redshift Cluster Management Task
SSIS Amazon Redshift Cluster Management Task
Amazon Redshift Data Transfer Task
SSIS Amazon Redshift Data Transfer Task (AWS Redshift Datawarehouse Bulk Copy, Import, Export)
Amazon Redshift ExecuteSql Task
SSIS Amazon Redshift ExecuteSQL Task (AWS Redshift Datawarehouse)
Amazon Storage Task
FAQs
How to loop through Amazon S3 files in SSIS
SSIS Amazon Storage Task (AWS S3)
Azure Storage Task
SSIS Azure Storage Task (Blob Storage)
Compression (Zip/Unzip) Task
SSIS Zip File Task (GZip,Zip,Unzip)
Download File Task
SSIS Download File Task
Export CSV File Task
SSIS Export CSV File Task
Export Excel File Task
SSIS Export Excel File Task
Export JSON File Task
SSIS Export JSON File Task
Export XML File Task
SSIS Export XML File Task
JSON Parser Task
SSIS JSON Parser Task
Logging Task
SSIS Logging Task
MongoDB ExecuteSQL Task
SSIS MongoDB ExecuteSQL Task
Regex Parser Task
SSIS Regex Parser Task
Reporting Services Task
SSIS Reporting Services Task (SSRS 2005, 2008, 2012)
Rest Api Task
SSIS Rest Api Web Service Task
Salesforce API Task
SSIS Salesforce API Task
Send HTML Email Task
SSIS Send HTML Email Task
SFTP Task
SSIS SFTP Task (Secure FTP, SFTP, FTPS)
Timer Task
SSIS Timer Task
Validation Task
SSIS Validation Task
XML Parser Task
SSIS XML Parser Task
PostgreSQL ExecuteSQL Task
SSIS PostgreSQL ExecuteSQL Task
Dynamic Properties / Parameterization for Tasks
Transforms
CSV Generator Transform
SSIS CSV Generator Transform
CSV Parser Transform
SSIS CSV Parser Transform
JSON Generator Transform
SSIS JSON Generator Transform
JSON Parser Transform
SSIS JSON Parser Transform
Set Variable Transform
SSIS Set Variable Transform
Template Transform
SSIS SSIS Template Transform
XML Generator Transform
SSIS XML Generator Transform
XML Parser Transform
SSIS XML Parser Transform
Dynamic Properties / Parameterization for Transforms
Source Adapters
Amazon DynamoDB Source
SSIS Amazon DynamoDB Source Adapter (Bulk Extract,Read,Copy NoSQL Data)
Amazon Redshift Source
SSIS Amazon Redshift Source
Amazon S3 CSV Source
SSIS Amazon S3 CSV Source
Amazon S3 JSON Source
SSIS Amazon S3 JSON Source
Amazon S3 XML Source
SSIS Amazon S3 XML Source
Amazon SQS Source
SSIS Amazon SQS Source
API Source
SSIS API Source
Azure Blob CSV Source
SSIS Azure Blob CSV Source
Azure Blob JSON Source
SSIS Azure Blob JSON Source
Azure Blob XML Source
SSIS Azure Blob XML Source
Azure Queue Storage Source
SSIS Azure Queue Storage Source
Azure Table Storage Source
SSIS Azure Table Storage Source Adapter (Bulk Extract,Read,Copy NoSQL Data)
CSV Source
SSIS CSV Source
DummyData Source
SSIS DummyData Source Adapter (Generate Fake Data for Testing)
Dynamics CRM Source
SSIS Dynamics CRM Source
Excel Source
SSIS Excel Source
Google Analytics Source
SSIS Google Analytics Source
HTML Table Source
SSIS HTML Table Source
JSON Source
SSIS Json Source Adapter (Bulk Extract,Read,Copy Json Records)
MongoDB Source
SSIS MongoDB Source Adapter (Bulk Extract,Read,Copy NoSQL Data)
PostgreSQL Source
SSIS PostgreSQL Source
Salesforce Source
SSIS Salesforce Source
Secure FTP CSV Source
SSIS Secure FTP CSV Source
Secure FTP JSON Source
SSIS Secure FTP JSON Source
Secure FTP XML Source
SSIS Secure FTP XML Source
XML Source
SSIS XML Source (File/SOAP/REST)
SSIS Parameterization for Components
Destination Adapters
Amazon DynamoDB Destination
SSIS Amazon DynamoDB Destination Adapter (Bulk Load,Write,Copy NoSQL Data)
Amazon Redshift Destination
SSIS Amazon Redshift Destination
Amazon S3 CSV Destination
SSIS Amazon S3 CSV Destination
Amazon SQS Destination
SSIS Amazon SQS Destination
API Destination
SSIS API Destination
Azure Blob CSV Destination
SSIS Azure Blob CSV Destination
Azure Queue Storage Destination
SSIS Azure Queue Storage Destination
Azure Table Storage Destination
SSIS Azure Table Destination Adapter (Bulk Load,Write,Copy NoSQL Data)
CSV File Destination
SSIS CSV File Destination
Dynamics CRM Destination
SSIS Dynamics CRM Destination
Excel Destination
SSIS Excel Destination
JSON File Destination
SSIS JSON File Destination
MongoDB Destination
SSIS MongoDB Destination Adapter (Bulk Load,Write,Copy NoSQL Data)
PostgreSQL Destination
SSIS PostgreSQL Destination
Salesforce Destination
SSIS Salesforce Destination
Secure FTP CSV Destination
SSIS Secure FTP CSV Destination
Trash Destination
SSIS Trash Destination Adapter (Dummy Destination for Testing)
Upsert Destination
SSIS Upsert Destination
Web API Destination
SSIS Web API Destination
XML File Destination
SSIS XML File Destination
Dynamic Properties / Parameterization for Components
Connection Managers
Amazon Redshift Connection Manager
Amazon Redshift Connection Manager
Amazon Storage Connection Manager
Amazon Storage Connection Manager
API Connection Manager
API Connection Manager
Azure Storage Connection Manager
Azure Storage Connection Manager
Dynamics CRM Connection Manager
Dynamics CRM Connection Manager
Google Data Connection Manager
Google Data Connection Manager
HTTP Connection Manager
HTTP Connection Manager
MongoDB Connection Manager
MongoDB Connection Manager
OAuth Connection Manager
OAuth Connection Manager
PostgreSql Connection Manager
PostgreSQL Connection Manager
Salesforce Connection Manager
SSIS Salesforce Connection Manager
Secure FTP Connection Manager
Secure FTP Connection Manager
SMTP Connection Manager
SMTP Connection Manager
Dynamic Properties / Parameterization for Connection
Useful Links
Licensing and Sales FAQs
How to activate product
How to extend trial period
How to transfer license
SSIS FAQs - Tips and Tricks
SSIS PowerPack FAQs
Knowledge Base
API Integration
API Connectors
All API Integrations
Amazon MWS (Marketplace API)
AWS
Azure
ConstantContact
eBay
ElasticSearch
Facebook
Google AdWords
Google API
Google BigQuery
Google DoubleClick
Google Maps
Hubspot
JIRA
Linkedin
Magento
MailChimp
NetSuite
Office 365 (Mail, Sharepoint, OneDrive)
QuickBooks
Salesforce
SAP S4 / HANA
ServiceNow
Sharepoint
Shopify
Smartsheet
Splunk
SurveyMonkey
Twitter
VSTS (TFS / Visual Studio Online)
Workday
Xero
Zendesk
Zoho
Zoom
Zuoro
Appendix
Format Specifiers / Placeholder Functions
Welcome
