Available Code Slices

The following is a list and description of the varying code slices that are available to use for free with SentryOne CodeSlice. Select a tab to learn more about the code slices:

Control Flow Slices

Control Flow Slices

SentryOne CodeSlice Insert Code slice for Control Flow
Insert Code slice Control Flow

SentryOne CodeSlice Select slice Control Flow
Select slice Control Flow

The following CodeSlices are available in the Control Flow :

SliceDescription
Add Delay (Suspend Thread)Pauses the Control Flow for a specified amount of time.
Archive File (Move - Copy - Rename)Copies or moves a file to a new location. You can provide a new name to the copied or moved file using date time parts in the following syntax : MyFile_12_31_2009.txt
Count Lines in a FileReturns the number of lines present within a specified file.
Download File Over HTTPAllows you to download files from the internet or an intranet using HTTP / HTTPS. Note:  You can include download credentials and proxy information in this slice.
Execute PowerShell ScriptExecutes a PowerShell script within SSIS. Note:  All machines executing this script need the Windows Software Development Kit (SDK) installed.
Execute SSIS PackageExecutes an SSIS package(s) stored within the file system or MSDB. Note:  By executing the script through code, you can modify the properties within the package before execution.
Fast Search and Replace in FileSearches for and replaces any string within an existing file. Note:  This operation uses small memory buffers to get faster performance in larger files.
File CompressionCompresses a file using GZip (*.gz).
File DecompressionDecompresses a file using GZip (*.gz).
File ExistsChecks if a specified file exists. If the file exists, then this slice return true. If the slice doesn't exist, this slice returns false.
File in UseChecks if a specified file is in use. If the file is in use, then this slice returns true. If the file isn't in use, then this slice returns false.
Folder ExistsChecks if a specified folder exists. If the folder exists, then this slice returns true. If the folder doesn't exist, then this slice returns false.
Minimal Script TaskA script task with all extraneous comments and code removed.
NotificationUses the Notification Engine within BI xPress Server. Note:  You need an instance of BI xPress Server configured to receive events.
Write Content to File (Footer)Adds data to the end of a file.
Write Content to File (Header and Footer)Adds data to the front and back of a file. Note:  You can use this script to add wrapper tags in XML data.
Write Content to File (Header)Adds data to the front of a file.
Write Content to File (Overwrite)Writes data to the file, overwriting the current file content. 

For more information about configuring a code slice in your SSIS package, see Using CodeSlice.

Data Flow Slices

Data Flow Slices

SentryOne CodeSlice Insert Code Slice for Data Flow
Insert Code slice Data Flow

SentryOne CodeSlice Select slice Data Flow
Select slice Data Flow

The following CodeSlices are available in the Data Flow :

SliceDescription
Minimal Script Component (Transform)A script component with all extraneous comments and code removed.
XML Destination Example (Destination)Used for writing the input from a data flow to an XML file.
XML Soure Example (Source)Used for reading from an XML file and outputting to a data flow pipeline.

For more information about configuring a code slice in your SSIS package, see Using CodeSlice.