Login   Register  
PHP Classes
elePHPant
Icontem

File: ssis.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of David Passey  >  ZEND_EPS_DTEXEC  >  ssis.php  >  Download  
File: ssis.php
Role: Example script
Content type: text/plain
Description: Example Script
Class: ZEND_EPS_DTEXEC
Execute Microsoft SSIS packages using dtexec tool
Author: By
Last change: Added comment.
Added 2nd paramater to the class instance to reflect a change to the class.
Date: 2011-03-16 11:44
Size: 782 bytes
 

Contents

Class file image Download
<?php
/**
* This simple script creates a new instance of the ZEND_EPS_DTEXEC class and:
* 1) sets the path of the config file to load and the name of the parent node
* 2) sets the package name to process
* 3) sets some optional reporting options (Warnings, Errors, and Processing info)
* 4) executes the package and returns back some statistics info
*
* See the code for comments or create your own documentation using phpDocumentor.
*
* Change the require path as needed.
*/

    
require_once 'lib/class.zend.eps_dtexec.inc';

    
$dts = new ZEND_EPS_DTEXEC('d:/temp/ssis_config.xml','env');

    
$dts->setPackage('test_package_1');

    
$dts->setReportOptions(array('w','e','p'));

    if (
$dts->exec()) echo $dts->statsObj->elapsed;
    else echo 
'package failed.';

?>