Allows the user to connect to multiple web services
Allows the user to push data to multiple web services
Helps synchronize two systems, no matter the source or destination, to conditionally insert or update data into a table
This control flow task will give you the ability to validate your delimited files before performing any downstream actions on that selected file
Sends or retrieves files in SSIS to a secure ftp server instead of writing a script task
Loads data warehouse fact tables in a fraction of the time and with much less development work
Used to read the properties of a file and set package variable values based on the settings provided
Component for SSIS that can output your data from one or many files into an XML file
Used to generate XML from one or more source inputs using an XSD mapped to input columns
Used to set up a connection to a SharePoint server
Reads data from the entities in a Microsoft Dynamics Server
Used to conditionally route rows to different outputs depending on the expression defined by using columns, variables, and expressions
Allows the user to move or delete messages downloaded using the Email Source
Brings easy to use PGP encryption, decryption, file signing and verification to SSIS that is based on OpenPGP technology
Compress files within SSIS by up to 90%, allowing greater speed and less network space
Allows the user to format the case of source data using different styles of formatting
Allows the user to remove unwanted characters or words from source data
An SSIS component where users can choose from a selection of algorithms to easily create hash values from input columns
Allows users to connect to a Hadoop Web HDFS instance and retrieve the contents of large text files. Data is easily parsed into columns in SSIS and streamed into the data flow
Used to connect to an Azure Machine Learning blob storage
Greatest Support Tech of All Time
Task that allows you to take full advantage of the 180+ functions in our Expression Engine to set variables.
A control flow component that can be used to refresh Excel Power Query and Power Pivot tables in SSIS.
SSIS component that allows the user configure options to pause the processing of packages.
Task is used for downloading files with the HTTP protocol from within SSIS.
Uses OpenXML to read an Excel worksheet and send rows into a data flow.
An SSIS component that allows the user to connect error outputs to it from sources and transforms.
An SSIS component that allows the user to replace null or blank values from their source data with a user defined value.
Allows users to take packed /stuffed XML or delimited text data from a source column and parse it out into separate user defined columns in SSIS.
Allows you to connect SSIS to Twitter to gain followers' information.
Quiz Playlist
Details
Clickable: Select answers by clicking on text or image buttons
In order to create a playlist on Sporcle, you need to verify the email address you used during registration. Go to your Sporcle Settings to finish the process.
Comments