DSXchange

Well, because with it I have different problems.
I have fields in hebrew that doesn't translate (I get question marks) when I use this stage

Hi ArndW. First of all, thank you very much for the quick reply. Did you mean that we will change in the odbc stage to double or in a transformer afterward? If I change in the odbc I will get a warning for data type mismatch. If I do it in a transformer after the odbc stage it doesn't change. Just t...

Hi all, hope you could help me. I have a server job that read from MSSQL table with ODBC stage. There is a field that defined as float in the table. When I read it with ODBC stage I get the value 624.15999999999997, when I read the same field (and the same row) in any other way (directly from the MS...

Hi all, I have a problem with specific routine when import and export between projects and then run multiple job compile (with check on the compile server routines). The routine behave like the older version that was in the project and only after I open the routine and compile specifically it change...

Hello all,
Does any one know if there is a way to use the user and password configured in the system dsn when trying to read from an sql server thru ODBC stage? (using SQL server authentication)?

Thanks in advance

Hello,
I have a problem when using large numbers in Datastage, Datastage round the least significant digits. Because of that, I can't compare those numbers.

Thanks from advance

SL1 is numeric and SL2 is List loop
Both sequencers are "Any"

Hello, I have a problem with a sequence that stop in the middle of the loop without any error or warning, only an info message: Note: Sequencer 'S2' was entered, but never exited I tried to display my Sequence here: UV= UserVariables Activity SL=Start Loop Activity EL=End Loop Activity JA=Job Activi...

Hello, I'm trying to read a XML file from an internet site. The problem is that there is a proxy server in the organization that all the internet connections should go through it. When I connect to the site with the explorer, the explorer direct me automatically to the proxy server, but when I conne...

Sorry, I don't understand the question.
If its regards the time between 7:00 to 08:30 then it was me who changed the time, regardless to the problem

Hello, I have a problem with one sequence job. When I schedule it, it inserts two rows exactly the same into the scheduler screen. When I unscheduled one of them, it removes both of them. I tried to do restart to DS services but it didn't help. Also, I changed the time of schedule from 7:00 to 08:30...

Hi,
I've checked all the permissions, the project dir, the Ascential dir and the temp dir. I have full control.
Amos, I didn't get to the part which I choose the data source. I just click on the arrow that gives me the list of DSN and it gives me that message.

Hi, The problem occur when I do Import from the table definitions and choose ODBC Table Definitions , Then, in the Import Meta Data (ODBC) window when I try to choose a DSN I get the following message: DSR.MetaGeta: Cannot open file DS_METATEMP I believe it's related to the project definition but I ...

Hi, "Didn't work" means that I get invalid data like this: ???? About the CFF stage, its a good idea but the ODBC stage throughes warnings about the invalid data. this is the warning: ds_mapnls() - NLS input mapping error, row 16, column KLLI data '????' external 011A1A02903F Do you have a...

Hi, I can't use the CFF stage because the customer wants a direct access and not through FTP or XCOM or something like that. I guess there isn't a way to do it through CFF stage. So, back to the unpacking, which NLS should I use? and should I change the field (the char(503) field) to binary? Cause I...