Advanced SSIS File System Task

• Validate business process in few clicks.
• SSIS Expression check for validation
• File/folder property validation such as file exists, check size, check content
• Support for regular expression based validation rules

• Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
• Support for windows or basic authentication
• Save response to variable or file
• Filter JSON response using JSONPath to extract specific value inside response text

• Send HTML Formatted email from direct text or template file
• Support for Placeholders (e.g. just type SSIS variable like {{User::varFirstName}} any where in Body or Subject and at runtime it will be replaced by variable value)
• This can be used to send news letters or mass emails to customers
• Support for Custom SMTP connection manager which allows you to enter UserID, Password and Port (There options not present in native SSIS Email Task)
• Support for RowSet variable place holder. It automatically expands as HTML formatted table in email when variable is object type and content is Recordset or DataTable set from ExecuteSQL task or ScriptTask

• Export multiple tables/views to Excel files (e.g. Sales% or do SalesJan|SalesFeb)
• Export SQL query output to Excel file
• Completely dynamic approach without limitation of DataFlow Stict Metadata
• Option to export data to specific starting location in Excel Sheet (e.g A5 will start writng to 5th row 1st column)
• Support for Password protected excel file

• Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
• Export SQL query output to JSON file
• Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
• Automatically Split exported JSON data into multiple files by Size or Number of records

• Export multiple tables/views to CSV files (e.g. Sales% or do SalesJan|SalesFeb)
• Export SQL query output to CSV file
• Completely dynamic approach without limitation of DataFlow Stict Metadata
• Split exported CSV data into multiple files by Size or Number of records

• More than 30 cloud operations for Amazon S3 Cloud Storage (Such as Download, Upload, Copy, Delete…)
• Download small/very large Amazon S3 Cloud Storage file(s) to local machine
• Upload small/very large local file(s) to Amazon S3 Cloud Storage
• Parallel download/upload using multiple thread for faster operations
• Support for Delete, Rename, List, Get Property, Copy, Move, Create, Set Permission … and many more operations

Read more …

• Bulk import data to aws redshift.
• Source can be ODBC, OLEDB, ADO.net, Flat File, Compressed Files (*.gz).
• Automatic file archiving after transfer.
• Parallel processing with multiple threads.
• Data compression support.

Read more …

• Automate report export/email process.
• Support for SSRS 2005/2008/2012.
• Support for Sharepoint Integrated Mode.
• Export report in xls, pdf, doc, xml, mhtml and csv format
• Support for Data Driver export process. You can configure reports, recipients, file format and many other options for automated export

Read more …

• Extract XML data from any SOAP/REST API Service or from local XML files.
• Support for wildcard to load multiple XML files without setting up complex looping.
• Support for XML Path query to filter data.
• Support for Paging, Passing custom headers to SOAP or REST Webservice

• Scrap HTML Tables from any URL or HTML file (Direct URL mode or Read from SSIS variable)
• Support for scrapping multiple URLs and combining resultset
• Options to Skip Header rows footer rows
• Automatically detect groups
• Automatically assigns row number to extracted record
• Extract/Scrap HTML Table data by Table Number, CSS name used for TABLE tag or use XPath for very flexible scraping
• Preview support without running actual package

• Extract data from JSON string (stored in variable) or JSON file.
• Support for JPath query to filter JSON data.
• Support for very large JSON files (streaming data).

Read more …

• Fast data extract from Azure Table Storage.
• Support for SQL query language (Proprietary parsing engine translates SQL query into Azure Table query).

Read more …

• Bulk insert data to Azure Table Storage.
• Option to define batch size for efficient data insert.

Read more …