Win32::SqlServer::DTS::Task::DynamicProperty - a subclass of Win32::SqlServer::DTS::Task to represent a DTSDynamicPropertiesTask object
use warnings; use strict; use Win32::SqlServer::DTS::Application; use Test::More; use XML::Simple; my $xml = XML::Simple->new(); my $config = $xml->XMLin('test-config.xml'); my $app = Win32::SqlServer::DTS::Application->new($config->{credential}); my $package = $app->get_db_package( { id => '', version_id => '', name => $config->{package}, package_password => '' } ); my $iterator = $package->get_dynamic_props(); while ( my $dyn_prop = $iterator->() ) { print $dyn_prop->to_string(), "\n"; } my $assign_iterator = $dyn_props->get_assignments; while ( my $assignment = $assign_iterator->() ) { print $assignment->to_string, "\n"; }
Win32::SqlServer::DTS::Task::DynamicProperty represents a DTS DynamicPropertiesTask task.
Win32::SqlServer::DTS::Task::DynamicProperty
DynamicPropertiesTask
Nothing.
Win32::SqlServer::DTS::Task::DynamicProperty inherits all methods from Win32::SqlServer::DTS::Task, overriding those that are necessary.
Win32::SqlServer::DTS::Task
Returns a integer with the number of assignments the DynamicPropertiesTask object has.
Returns a iterator, that, at each call, will return an Win32::SqlServer::DTS::Assignment object until there are no more assignments in the Win32::SqlServer::DTS::Task::DynamicProperty.
Win32::SqlServer::DTS::Assignment
See "SYNOPSIS" to see an example of usage.
Returns a string with all attributes of an Win32::SqlServer::DTS::Task::DynamicProperty class. All attributes will have a short description and will be separated by a new line character.
Win32::SqlServer::DTS::Task at perldoc.
perldoc
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.
Alceu Rodrigues de Freitas Junior, <arfreitas@cpan.org>
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.
To install Win32::SqlServer::DTS, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Win32::SqlServer::DTS
CPAN shell
perl -MCPAN -e shell install Win32::SqlServer::DTS
For more information on module installation, please visit the detailed CPAN module installation guide.