DSXchange

Hi ray Itried this routine but when compileing it giving the following error. Compiling: Source = 'DSU_BP/DSU.ren', Object = 'DSU_BP.O/DSU.ren' 0002 #include "stdio.h" ^ Can't open $INCLUDE file 'DSU_BP/"stdio.h"' Is there anything else I need to do not much experience in C++ any...

Thanks jwles we were reading zip file instead of txt file.

samdsx wrote:Job parameters.

I am using job parameters but nothing is wrong here.. it is running fine when I run idividually but in sequence it is geeting aborted.

samdsx wrote:compare variables used by job when run from sequence and run individually and see if there is any difference.

Hi samdx

Do you mean user variables or enviornment variables?

Hi All I am running a job which is running fine.but when I run the same job with sequence it is getting aborted due to this error. Error: Consumed more than 100000 bytes looking for record delimeter not found. My source file is a fixed width file. In the format I gave Record Delimeter String =DOS Fo...

chulett wrote:Therefore, the syntax is incorrect. :D

Hi Chutlet thanks for correcting me. What you said is right.
Thanks for all

Hi chutlet I tried in transformer with this syntax

in.column[1,4]:in.column[6,7]:in.column[9,10] when I validated this syntax it is valid I could not find any syntax errors if you could correct me that would be great.

Thanks M

hi chutlet

Is there nay way to do chutlet....I am trying to remove "-" so that it becomes integer but could you tell me how to acheive it.
Thanks M

hi I am having a source column as timestamp and my target column is integer. column 2011-07-29 00:00:00.000 in xfm I am doing in.column[1,4]:in.column[6,7]:in.column[9,10] but is is giving me 0 in the output I did this beofre it worked long back but now it is not working.could you tell me what is th...

abc~#asdf~#hdsajds

these are the column names how to import the sqeuential file table definition. I tried with sequential file table definitions but not working.

Any ideas really helpfull

Hi
my data is like this


abc~#asdf~#hdsajds
the delmiter is ~# how do we read this I tried giving the delimiter as ~# but it is reading #also how to avoid this

Thanks
M

Hi Williams thanks for your reply !! Unfortunately we can not touch triggers on that table but work around is keeping record count as 1.. then it is loading full data.... We dont have access to disable triggers so I am loading now with record count 1..... I will investigate on this if I get anything...

chulett wrote:I'm sorry... you are using this "record count > 1" where?

If I give record count as 1 its running fine with odbc connector stage but if give from 2 it is loading partial data...

I have triggers on the table but I dnt have reject link it is dropping the records in target if give record count >1

Hi, I am facing problem while loading data from source sql server - target sql server. stage using odbc connector If I change record count to >1 then it is not loading full data it is loading only some records but if I change record count>1 then it is loading full data. I am not able to understand a...