DSXchange

Sweet, Got it. I didn't read the requirements for the UtilityRunJob() close enough. I was passing it the value of my variable. The Arguments clearly state that I needed to pass it as ParamName1=Value1|ParamName2=Value2 My SQL has been modified to : SELECT 'FILENAME=D:\External\Outbound\EXTRACT_002\'...

I don't think so. Using the server method - I have: http://photoberkit.com/copper/albums/userpics/10032/ds_samp.jpg The Transformer calls my Job using: UtilityRunJob('Export_Job', CONFIG.PRAM, 0, 0) In the job that the Transformer calls, how do I configure my parameters to receive the parameter sent...

Ah ha! Very helpful - Thanks.

I think the only thing I'm missing is the technique to split the parameters back apart in the Job I am running.

If it helps - Below is the SQL i have in the Server Job. One column is being passed to the Transformer, Parm. SELECT 'D:\External\Outbound\EXTRACT_002\' + CUSTOMER_NAME + '\' + CYCLE + '\DH_'+CUSTOMER_NAME+'_'+CYCLE +'_ORD_TRACKING_'+ CONVERT(VARCHAR(10), GETDATE()-1, 112) + '.XLST|'+CUST_CODES PRAM...

deleted

The first parameter is FileName. It is used to place the file in the appropriate file hierarchy for the specified customer in the config table. The second parameter, CustAccountCode, is used in the Netezza Stage within the SQL where clause. As to the Server job - Check. Dummy Sequence is in place.

you might want to try using a Server job to read records from the table, then a Transformer stage to call the DSUtilityRunJob() function for each record. I've read about this technique - but I'm struggling to fill in the blanks. So, right now I have a Server job. It reads my SQL Server Config table...

Preface: I am new to Datastage. I have been doing ETL for 10ish years with SQL tools but I'm struggling a bit conforming to the ways of Datastage. I'm at the bottom of the learning curve. I've done the Datastage Essentials course and just submitted payment for premium status. I've authored roughly ...