SSIS Tasks Types03-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 firstname.lastname@example.org
#data #datavisualisation #datamodelling #datamart #powerbi #sql #excel #powerquery #azure #azureanalysis
No Comments to Show