/ 
DTS-0.07
/ DTS::AssignmentTypes

NAME

DTS::AssigmentTypes - a Perl abstract class that knows all DynamicPropertiesTaskAssignment objects types.

SYNOPSIS

    use DTS::AssignmentTypes;

	# assuming that $assignment is a DTS Dynamic Property assignment object
	my $type = DTS::AssignmentTypes->get_class_name($assignment->SourceType);

DESCRIPTION

DTS::AssignmentTypes is a simple abstract class that knows all existing types of DTS Dynamic Properties assignments types and how to convert those types to DTS::Assignment subclasses names.

This abstract class should be used only if one wants to extend the DTS API.

EXPORT

None by default.

METHODS

get_class_name

get_class_name is an abstract method that converts the numeric type code from DTS API constant DynamicPropertiesTaskSourceType to a proper string that represents a subclass of DTS::Assignment class. Returns one of the following strings, depending on the numeric code received as a parameter:

  • INI

  • Query

  • GlobalVar

  • EnvVar

  • Constant

  • DataFile

The valid types are:

SymbolValueDescription
DTSDynamicPropertiesSourceType_Constant 4 Source is a constant
DTSDynamicPropertiesSourceType_DataFile 5 Source is the contents of a data file
DTSDynamicPropertiesSourceType_EnvironmentVariable 3 Source is the value of a system environment variable
DTSDynamicPropertiesSourceType_GlobalVariable 2 Source is the value of a DTS global variable within the package
DTSDynamicPropertiesSourceType_IniFile 0 Source is the value of a key within an .ini file
DTSDynamicPropertiesSourceType_Query 1 Source is a value returned by an SQL query

SEE ALSO

  • DTS::Assignment at perldoc, as well it's subclasses.

  • DTS::AssignmentFactory at perldoc also uses the get_class_name method.

  • Win32::OLE at perldoc.

  • MSDN on Microsoft website and MS SQL Server 2000 Books Online are a reference about using DTS' object hierarchy, but one will need to convert examples written in VBScript to Perl code.

AUTHOR

Alceu Rodrigues de Freitas Junior, <arfreitas@cpan.org>

COPYRIGHT AND LICENSE

Copyright (C) 2006 by Alceu Rodrigues de Freitas Junior

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.