SSIS Tasks Types

03-09-2019  0 Comment(s)


In SSIS tool, you can add a task to control flow. There are different types of tasks which perform various kinds of works.

Execute SQL Task As its name suggests, it will execute a SQL statement against a relational database.
Data Flow Task This task can read data from one or more sources. Transform the data when it is in the memory and write it out against one or more destinations.
Analysis Services Processing Task Use this task to process objects of a Tabular model or as an SSAS cube.
Execute Package Task Use can use this SSIS task to execute other packages from within the same project.
Execute Process Task With the help of this task, you can specify command line parameters.
File System Task It performs manipulations in the file system. Like moving, renaming, deleting files, and creating directories.
FTP Tasks It allows you to perform basic FTP functionalities.


Sam Analytiks motivates, educates and proliferates data for any organisation as a non-profit partner. If you or any of your team member needs a help, surely our consultants will be glad to help you in any case.

Call us at +48-729473572 or email us at
#data #datavisualisation #datamodelling #datamart #powerbi #sql #excel #powerquery #azure #azureanalysis 

Comment Here


No Comments to Show