DSXchange

I do not know if this will solve ur issue or not but just my 2 cents -- Run-time error '70' is typically the result of a security or permissions issue. The following is a list of possible causes of run-time error 70 but is by no means a complete or definitive list. DCOM Is Not Enabled If the Server ...

May the process related to the job were not killed properly and it was still locked. Now that you waited for some time it would have timed out and u wud have gained access to the same.

It is Date().

It references a Hashed file. Open the routine and check out the code.

Did u try to run ur user defined upsert without using the environment variable? Reason to ask this is that may be the error is not because of the parameter but in the User defined Statement.

Also you can try to assign the column the env variable in a transformer prior to the TGT stage.

I am not sure if there is a process for it for not but this is what I used to do as a workaround --> 1. Click on the category where these jobs are present in director. 2. Sort by status. 3. Select all the jobs. 4. Click on print and print summary to a print file. 5. Open it with Excel and filter out...

I removed all the stages in the job and directly sourced the data from the source SQL table in to a Seq file.
I get the same result. Every character field is of lenght 1 in the file , so if a NAME = Mike , then in the file NAME = M.

Sorry Guys , Its not version 8 its Version 7.5. I am not sure how it got that 8.

No , length is provided in the source stage. The source stage is a DRS stage.

I have a job which reads from a SQL Server and writes to a Oracle Database. Its one to one job with IPCs in it. When Irun the job all the character fields from teh source are truncated to length 1 (without any errors) and are loaded in the target liek that. When I say view data I see the same result...

Aint this a Parallel Edition Question? Its in the wrong Forum..

Yes if it is a key (in DB and your Target Stage) and the strategy has INSERT in it.

Also Are you running any other jobs at the same time as this one.

Well the way that I know of is Datastage Manager > Usage Analysis.

Select the particular Job/s and run the usage analysis , this should give a report (you can see it in HTML format) with all job/s which are using the selected job/s.

Also check if there is an output link from this stage to any other stage such as a Hashed File and if the select statement in that one is ok...

There are many ways , to start with there is a command stage..you can use that,..

Same interview??