DSXchange

ODBC connector.
But in order to do that you will need an entry in the ini file.

Here is what you can try. Take the DSX of all the jobs. If you open the DSX in the edit mode the section of declaration of Parameter sets is towards the beginning (and its a standard kind of declaration). You can probably write a simple shell script to edit the DSXs and add these lines. Hopefully th...

Do you have an xsd for this output ?

for example
Table A - Bytes per record 100
No of records loaded last night 500
bytes loaded - 50000

That's the best that I can think of ...

Is there a reason that you dont wish to use transformer ?

Yea You will need to create an odbc entry for the databases that you want to import the tables from.

Yea What Ray said was more or less a last resort.. The reason behind this exercise is to see the amount of data that we are moving using ETL. Management request :) And it had me curious too I generated a performance Report for a job and That had a chart which had a bytes used by the job (doesn't loo...

Hey
I need to see how many bytes are moved by the data stage jobs.

tried a few Environment variables
like cc_msg_level
and some APT variables , no luck.
The job logs just show the record counts.

Is there any way ?

alright.
Here's what you can try.
Read the data as varchar. Use transformer to extract the data before the ' ' and then use type conversion function to change it to date.

Oh. OK I thought I read $APT variable -0 assumed user was talking about the adding the admin variables to the job. NVM

If its 'MM'/DD/YYY HH:MI shouldn't the data be 06.14.2014 16:07 ?

You should be fine either ways.

if nothing works.

Split the input decimal number into 2 (delimit on decimal point). 1.signficand 2.mantissa

Leftpad the significand and right pad the mantissa with zeroes (length as pr requirement) and then concatenate the two.

@kiran_h Yes it is doable , But the manual additions are not straight forward. For Environment variables its more complicated and for parameter sets its less so. For Parameter Sets you may just need to add a bunch of statements towards the declaration section of the DSX but for the ENvironment varia...

Try the same process but instead of the taking a standard dsx may be try with the XML option. I ll try and replicate the this here. WIll let you know what I find POST - edit So I did this experiment at my end. Simple job. Took the dsx , changed the job took the dsx (added an environment variable and...