Common SSIS package-execute tasks

Executing a task will execute one or moreSQLStatement or stored procedure. InSSISIn the execution FileScript. Most of the configurations are3-1. Stop TimeTimeoutOption to set the time when the task starts to stop. If it is set0It will be executed in a very short time.

Figure 3-1

 

ResultsetOption settingsTask. The default setting isNone. When you want to populate the output results with rows and result sets in a table,XMLChinese options are useful. . If this setting is notNoneYou will set the output result on the result settings page. On the results page, you can map the output results to user variables and create a new user variable. This user variable can be a container or the entirePackage.

 

You canPackageUse this output result set. One example is to check the values in a table.PacakgeIf the value is1Prove thisPackageAfter the execution is completed, you can execute the nextTaskOtherwise, re-executePackage.

 

Connection Type propertyConnectiontype, Set and executeSQLThe link type used in the statement. Options include:Ole db, ODBC, ADO, ADO. net, Excel,AndSqlmobile. If yesSQL ServerConnection SelectionOLE DBSet other connection attributes. YourSQL queryIt can be saved as a face change, input a file, or input directly. AvailableSQL queryStorage location. You can also set the data source type options.SqlsourcetypeAnd then enter or select a value from the drop-down list. The next option isSQLStatement, ifSqlsourcetypeSelectDirect inputIn this case, you need to set the options. There are two options:Sourcevariable,Fileconnection.

 

IfConnectiontypeSelectADOSoIsquerystoredprocedureThis setting is also available.QueryWhether it is a stored procedure. If noADOThis option cannot be set. IfOLE DBData Source support, you can setBypassprepare. PreparedSQL queryCan be cached, And the next execution speed will be faster. Select NewQueryWhenVisual StudioHas the same editing environment.