/ 
DTS-0.06
/ 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:

Symbol                                             Value  Description
---------------------------------------------------------------------------------------------------------------
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.