tMSSqlColumnList – Talend Components V6.5.1.20180116_1512

tMSSqlColumnList
Name: tMSSqlColumnList
Icon: tMSSqlColumnList
Description: Iterates on all column names in a specified table from a defined MSSql connection
Author: Talend
Version: 6.5.1.20180116_1512
Download:

tMSSqlColumnList V-6.5.1.20180116_1512 – Direct download
Example: Coming soon…
Install Instructions:
  • 1.Close your studio
  • 2.Extract the content of tMSSqlColumnList.zip in a temporary folder
  • 3.Copy the content of tMSSqlColumnList into your studio installation path to components folder: Talend-Studio -> plugins -> org.talend.designer.components.localprovider_[version_timestamp] -> components
Release Date: 20050320A
Families:
  • Databases/MS_SQL_Server
Returns:
Name Type Description
COLUMN_NAME id_String Column Name
COLUMN_DEFAULT id_String Column Default
IS_NULLABLE id_String Is Nullable
DATA_TYPE id_String Data Type
CHARACTER_MAXIMUM_LENGTH id_String Character Maximum Length
CHARACTER_OCTET_LENGTH id_String Character Octet Length
NUMERIC_PRECISION id_String Numeric Precision
NUMERIC_PRECISION_RADIX id_String Numeric Precision Radix
NUMERIC_SCALE id_String Numeric Scale
DATETIME_PRECISION id_String Datetime Precision
COLUMN_KEY id_String Column Key
NB_COLUMN id_Integer Number of Column
Connectors:
  • FLOW
  • ITERATE
  • SUBJOB_OK
  • SUBJOB_ERROR
  • COMPONENT_OK
  • COMPONENT_ERROR
  • RUN_IF
Imports:
Overview:
Component get from Talend
Thank you for watching.

Was this article helpful?

Yes No
Tagged:

Related Articles

Leave A Comment?