DSXchange

Hi Krishna, <?xml version="1.0" encoding="ISO-8859-1"?> <fileUpdate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1" program="XXXX" vendor="XXXXX" createDate="2010-12-10 01:50:11" serviceType="2"> <fileL...

Hi krishna,

I have only one output stage, I have unchecked and checked doesnt may any difference. Still showing the header

Any other options to do please help

Thanks
Goutam

Hi Vignesh,

I have tried this , This is xml output stage , i have checked comment in stage tab --->document settings tab but doesnt remove the header
can you please suggest if there is any other way.

Thanks

Hi Friends,

Im getting this message on top of my xml file,
<?xml version="1.0" encoding="ISO-8859-1"?>
Can anyone help me/suggest how to remove this message from the file

regards
goutam

Hi Friends, My source is a flat file and output is xml output stage. targeted output is : <fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2"> 0000000000000000001. <fileList> <file preReqFile="" i...

Hi Friends

Can anyone help me

How to read from an excel sheet in linux?

are there any ODBC drivers for free available


Thanks

ray.wurlod wrote:You will need to separate the date and time components. Get these date arithmetic routines and add 4 days to the da ...

Hi Ray,

I dont have the premium membership can you please help me with the code

Thanks

Hi Friends,

I am getting a column(DATE)Timestamp in transformer stage say ex 29-05-2010 06:00:00 I want to add +4 days in the transformer stage.

when I say DATE+4 in transformer stage it doesnt work can anyone help me with function or the way to add 4 days for the input DATE


Thanks

If you are loooking for some database encryption and decryption package then I may suggest you some clues,i think you can use this SP from backend and try to achieve what you are looking for this SP is based on oracle database , Let me know which database you are looking for you may have to convert...

Try using parameter sets. HI Sorrell, Is it possible to encrypt a password and use the encrypted password as input parameter for db connection without decrypting it in DS 8.1, The scenario is our testing team should use the encrypted password only in the param file as input for the job for connecti...

Hi Ray,

I want the first original password to be converted into encrypted and then use this encrypted as a password for the jobs for connecting to database by assigning to a parameter.

does this work If I use convert()?

ray.wurlod wrote:There are literally zillions of different encryption algorithms out there, from simple substitution through to 128-bit private key encryption. How strong do you need the encryption to be? Do you nee ...

I just need a simple subtitution of original pwd,

Thanks

ray.wurlod wrote:This was seen as a security breach and tightened.

There is a proper, rigorous way to manage passwords. Use that. ...

Hi Ray,

Thanks for the reply, But can you please help me with procedure to write a pwd in encrypted format using DS 8.1

I actually want to give this encrypted password to the testing team to use as a parameter for the job. Instead of giving the original password. We want to restrict them to access oracle table access directly. This is possible in DS 7.5 server edition, where as in DS 8.1 edition it is throwing out on...

I am just curious! What you are trying to do with the encrypted password? I actually wanted the testing team to use this encrypted password. DS 7.1 director shows as SOURCE_DB_P=D1.WORLD SOURCE_DB_USER_P=D_04 SOURCE_DB_PASSWORD_P= L5J@I9V1?9KL0?4IE9N<@OA7 ODS_DB_P=D1.WORLD ODS_DB_USER_P=D_05 ODS_DB...