DSXchange

I think you dont have premission on this, check and try to do one more time.

the below post may be helpful to you.

viewtopic.php?t=91945

Thanks
Sreee

Try to check your odbc drive connection and if your execl may be correct, delete and try to do one more time.

If hope the below answer is enough for your question, if you are still struggling to get your output. I hope your are using transformtion stage in your job, go to column right click and go to string and you can frind trim and use this. Regards, Sree [quote="hargun"]Hi, i have column name B...

If you have idea , how to use pivot in excel it is mostly same like this.

viewtopic.php?t=89442

This link will help you.

Thanks
Sree

Hey , can you please clarify are you implementing ds job or are you implementing this logic in the any existing job. As per my knowledge we can use range lookup in the lkp stage. If not kindly ignore my answer. Example:- If you are using lkp you can add range lkp on based on your month and week use ...

As per my knowledge it is not possible in datastage, we can do in reporting level and which reporitng tool is used in your environment and discuss with them try to slove the requirment. Example:- In the reporting level we can use filter for the same column like below. As of yesterday balance = 1 Tod...

Try this one, may be help ful to you. 1.Log into Designer and open the job. 2.Open the job properties--> parameters-->add environment variable and select: APT_DEFAULT_TRANSPORT_BLOCK_SIZE 3.You can set this up to 256MB but you really shouldn't need to go over 1MB. NOTE: value is in KB For example to...

Try to load data in to peek, if you are using parellel jobs.
If that is working as per your requirmment.

Hi,
can you post the error or abort reason in your job.
Regards
sree

Hi DS Team, Can some one resolve my issue to convert "interger to decimal" How to convert interger value to decimal in Transformer stage.In the source "x" column data type is varchar and i am converting to interger using "AsInteger("X") in the same transformer i am...