Integrate Perl scripts into SSIS

Perl is such a powerful open source language with many modules for handling XML requests, whois lookups and database interfaces for all major open and closed commercial databases.

Being able to determine if a script has successfully run in SSIS is very important.

Using Perls exit value command allows the value of a successful execution to be passed to the SSIS process task.

Then set the value in SSIS;

Useful sources:

SSIS & SQL how to articles

Perl how to

To pass a variable from the perl script use the print command, it will be captured as a string in the SSIS 'StandardOutputVariable.  A useful how to guide here.