CozyRoc
Overview
Stream Task is SSIS Control Flow task for management and manipulation of standard Stream object.
Setup
Use the General page of the Stream Task Editor dialog to configure the options needed to work with a stream object.
Options
- Name
-
Specify task name.
- Description
-
Specify task description.
- StreamVariable
-
Specify the variable containing the manipulated stream object. Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- Action
-
Specify task action. This property has the options listed in the following table.
Value Description Create a stream Creates stream object. Selecting this value displays the dynamic options StreamType, IsFilenameVariable, Filename, FilenameVariable, OverwriteExisting. Open file stream Opens stream object to a file. Selecting this value displays the dynamic options IsFilenameVariable, Filename, FilenameVariable. Read from stream Reads data from stream. The result is array of bytes. Selecting this value displays the dynamic options Read, Terminator, Length, ResultVariable, CloseAtEnd. Write to stream Writes data to stream. Selecting this value displays the dynamic options Write, IsTextVariable, Text, TextVariable, InputStreamVariable, CloseAtEnd.
- StreamType
-
Specify type of created stream object. This property has the options listed in the following table.
Value Description Normal Creates file stream. Memory Creates memory stream. Transfer Creates transfer stream. This stream is useful for transferring data between processes. It allows simultaneous writing of data in one process and reading this same data in another process.
- IsFilenameVariable
-
Indicates whether the file name is stored in a variable. This property has the options listed in the following table.
Value Description True The file name is stored in a variable. Selecting the value displays the dynamic option FilenameVariable. False The file name is specified in a File connection manager. Selecting the value displays the dynamic option Filename.
- Filename
-
Select an existing File connection manager, or click <New connection...> to create a connection manager.
Related topics: File Connection Manager Editor
- FilenameVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- OverwriteExisting
-
Specify to overwrite existing file.
- Read
-
Specify type of read from stream object. This property has the options listed in the following table.
Value Description Terminator Reads from stream until specified terminator combination is reached. Length Reads fixed length from stream.
- Terminator
-
Specify terminator, which controls when reading should stop.
- Length
-
Specify fixed length to read from stream.
- ResultVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- CloseAtEnd
-
Specify to close stream at the end of action.
- Write
-
Specify type of write to stream object. This property has the options listed in the following table.
Value Description Text Writes text to stream. Input stream Writes another stream to target stream.
- IsTextVariable
-
Indicates whether the text is stored in a variable. This property has the options listed in the following table.
Value Description True The text is stored in a variable. Selecting the value displays the dynamic option TextVariable. False The text is specified. Selecting the value displays the dynamic option Text.
- Text
-
Specify text.
- TextVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- InputStreamVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable