Valid DTSCLI parcel filters include the following types:
The two main parcel filters used are either binary or text. Use the text filter if transferring text files between two different types of computers (Windows XP and UNIX, for example). This ensures that the text format is preserved; otherwise, always use binary filters.
Note: Binary and text filters are mutually exclusive: A transfer can either be text or binary but not both.
Help for adding filters to agent transfers is given by the command:
dtscli -help agent p_filters
Example: Transfer a File as Text
dtscli -agent "ipath=Gold::c:\dtstemp\file.src"
"rpath=Silver::c:\dtstemp\file.dest" "p_filters=text"
dtscli -agent "ipath=Gold::c:\dtstemp\file.src"
"rpath=Silver::c:\dtstemp\file.dest" "p_filters=TEXT_READ:TEXT_WRITE"
Note: Only use text filters for transferring text files.
Example: Compress a Text File
dtscli -agent "ipath=Gold::c:\dtstemp\file.src"
"rpath=Silver::c:\dtstemp\file.dest" "p_filters=text compress"
dtscli -agent "ipath=Gold::c:\dtstemp\file.src"
"rpath=Silver::c:\dtstemp\file.dest" "p_filters=TEXT_READ:TEXT_WRITE HUFFMAN_COMPRESS:HUFFMAN_UNCOMPRESS"
Example: Add Multiple Parcel Filters
dtscli -agent "ipath=Gold::c:\dtstemp\file.src"
"rpath=Silver::c:\dtstemp\file.dest" "p_filters=binary compress”
dtscli -agent "ipath=Gold::c:\dtstemp\file.src"
"rpath=Silver::c:\dtstemp\file.dest" "p_filters=BINARY_READ:BINARY_WRITE HUFFMAN_COMPRESS:HUFFMAN_UNCOMPRESS"
The order in which the filters are listed is important. The binary filter must be listed before the compression filter. For example, try swapping the filters around; call the compression filter first, then the binary filter. You will notice that the transfer fails.
Note: Always make sure that either the binary or text filter is first in the list.
|
Copyright © 2013 CA.
All rights reserved.
|
|