Previous Topic: dtscli Command—Manage Transfer JobsNext Topic: Use Skip Logic in a Sequential Transfer Job


dtscli Command—Use Skip Logic

Skip logic is most useful when the success or failure of one or more specific transfers determines which other transfers should be activated or skipped. You can specify one or both skip logic settings (CSKIP= and FSKIP=) for a transfer.

The following table lists some representative skip logic settings and their results:

Values

If Transfer Completes

If Transfer Fails

cskip=1
fskip=2

Next transfer is skipped.

Next two transfers are skipped.

*fskip=0

Next transfer is activated.

Next transfer is activated.

*cskip=-1

No more transfers are activated.

No more transfers are activated.

fskip=I450

Next transfer is activated.

The next transfers until transfer 450 are skipped. Transfer 450 is activated.

fskip=

LtransferOne

Next transfer is activated.

The next transfers until the transfer with the label “TransferOne” are skipped. This transfer is activated.

fskip=

NtransferTwo

Next transfer is activated.

The next transfers until the transfer with the name “TransferTwo” are skipped. This transfer is then activated.

*In these cases, the 0 or -1 value specifies that there is no skip logic to perform.

More information:

dtscli -transfer Parameter Group—Perform Managed Transfers

dtscli -job Parameter Group—Manage Transfer Jobs