DSXchange

[quote="ray.wurlod"]Please wrap your "design" in Code tags to preserve its format.[/quote] Hello all, In my job I am passing sqlquery as parameter (JOB PARAMETER : SQL_QUERY). [code] Source | | | | Transfomer----> Oracle_enterprise1 | | | | | Target I need to load this same sqlqu...

Hello all, In my job I am passing sqlquery as parameter (JOB PARAMETER : SQL_QUERY). [code] Source | | | Transformer--> Oracle_enterprise1(log for SQL_QUERY) | | | Target [/code] I need to load this same sqlquery into a table(Oracle_enterprise1) for log. So for that I am using a transformer where i ...

[quote="anbu"]I dont see log for user variables activity in any of my jobs. If the variables you created are used only once in a job then call the server routine directly in job activity instead of using user variable activity[/quote] Hi anbu, Thanks for the suggestion. My issue got resolv...

[quote="anbu"]Make the password job parameter as encrypted type in the job[/quote] Hi anbu, Thanks for the quick response :) Actually using User Variable Activity I am passing the password as parameter to the nextjob where I made it as encrypted. But when I see the log of the sequence, for...

Hi all, In my requirement I need to pull sqlquery,username and password from a table and pass them as parameters to the next job. So for that I landed the sqlquery and credentials in a sqlfile. Using server routine I parsed them and passed to the next job with user variable activity. This flow works...