com.toolsverse.etl.core.task.sqlserver

Class MsSqlExtractTask

Object

com.toolsverse.etl.core.task.common.CmdTask

com.toolsverse.etl.core.task.sqlserver.BcpTask

com.toolsverse.etl.core.task.sqlserver.MsSqlBcpTask

com.toolsverse.etl.core.task.sqlserver.MsSqlExtractTask

All Implemented Interfaces:

OnTask, SupportsCodeUpdate, SupportsRecording

public class MsSqlExtractTask
extends MsSqlBcpTask

This is a Microsoft Sql Server specific Task.POST task which extracts data into the text file using sql. The Microsoft BCP program must be installed in the same computer which runs etl scenario.

Since:

1.0

Version:

2.0

See Also:

Task

Field Summary

Fields inherited from class com.toolsverse.etl.core.task.sqlserver.BcpTask

CONNECTION_ATTR, SQL_ATTR

Fields inherited from class com.toolsverse.etl.core.task.common.CmdTask

CMD_ATTR, ERROR_MASK_ATTR, KEEP_LOG_VAR, SUCCESS_MASK_ATTR

Constructor Summary

Constructors

Constructor and Description
MsSqlExtractTask()

Method Summary

Modifier and Type	Method and Description
Map<String,Object>	getDefaultValues(Task task) Gets the default values for the model used to edit task.
String	getResourceName(Task task) Gets the name of the xml file used to create a model for the task editor.
String	getSql(EtlConfig config, Task task, String datFileName, String params) Gets the sql to execute.

Methods inherited from class com.toolsverse.etl.core.task.sqlserver.MsSqlBcpTask

getServer

Methods inherited from class com.toolsverse.etl.core.task.sqlserver.BcpTask

executePostTask

Methods inherited from class com.toolsverse.etl.core.task.common.CmdTask

executeBeforeEtlTask, executeInlineTask, executePreTask, getCodeLanguage, getTitle, init, isInlineTask, isPostTask, isPreEtlTask, isPreTask

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MsSqlExtractTask

public MsSqlExtractTask()

Method Detail

getDefaultValues

public Map<String,Object> getDefaultValues(Task task)

Description copied from interface: OnTask

Gets the default values for the model used to edit task.

Specified by:

getDefaultValues in interface OnTask

Overrides:

getDefaultValues in class CmdTask

Parameters:

task - the task

Returns:

the default values

getResourceName

public String getResourceName(Task task)

Description copied from interface: OnTask

Gets the name of the xml file used to create a model for the task editor.

Specified by:

getResourceName in interface OnTask

Overrides:

getResourceName in class CmdTask

Parameters:

task - the task

Returns:

the resource name

getSql

public String getSql(EtlConfig config,
                     Task task,
                     String datFileName,
                     String params)

Description copied from class: BcpTask

Gets the sql to execute.

Specified by:

getSql in class BcpTask

Parameters:

config - the el config

task - the task

datFileName - the data file name

params - the params

Returns:

the sql