Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsiddiqi
Starting Member
4 Posts |
 Posted - 2005-08-24 : 12:42:56
|
| Hey..i'm learning perl on the fly so i aplogize in advance if i'm making some critical silly errors. I included some functions in a .pm module, and called them from a .pl perl script. That seemed to work great, now, i'm trying to call the same .pm module from an active script in DTS, and its giving me "Function Not Found" error for the functions in the .pm. I used the following code eval { require BI::etl::dfa}; if ($@) { $DTSGlobalVariables->Item("perlPath")->{Value} = "not found"; } else { $DTSGlobalVariables->Item("perlPath")->{Value} = "found";} and i got a "found", so seems like it is recognizing the .pm but still gives me a function not found error for functions within the .pm I was having a similar problem when i was debugging the .pl perl file, and i realized i had to include the functions i wanted to pass on into the @EXPORT array in the .pm file (use Exporter), which then worked fine. Do i need to do something similar so i can carry on the function names into the Active Scripts in DTS? Any suggestions on how to do this...perhaps a different approach to include perl modules in DTS Active Script Task? Thanks |
|
|
|
|
|
Perl Module Call in Active Script Problems