DSXchange

Oops !

"From previous run" is what I called "after run"...

Pierre.

Hi, I have a simple job that usually works fine, but today, I have the followin error : Abnormal termination of stage C004EF05ServicesRentalVehicule.BE.TR detected and (after run) : From previous run DataStage Job 692 Phantom 2344 Unhandled exception raised at address 0x1F9FB051 : Access violation A...

Hi, I have a job (Multi instance, with unique invocation, launched by a Job control) that runs every day without any problem, takin less than 1 sec. It contains one SQL Server IN, one SQL Server LKP, and two SQL Server Outputs. This morning, it was still running after more than 4 hours, with 0 lines...

Hi,

I've just test it, and for me it works fine, I don't see where's your problem.
Did you refresh the repository ?

Pierre.

from my project dir (Ascential\Datastage\Projects\MyProject), I launch

!DirDSBin!\dssh SELECT CATEGORY FMT'80L', NAME FMT'80L' FROM DS_JOBS WHERE NAME NOT LIKE '\%%' ORDER BY CATEGORY, NAME; > OutputFile.csv

where !DirDSBin! is my Ascential\Datastage\engine\bin dir.

I faced this problem several times (with DS Server).
Clearing the log reduced the startup time.

Pierre.

Craig wrote

Or there's always the front door. Open the Sequence job / Job Properties / Dependencies tab for a list of all the jobs the Sequence runs.

Yes, but not necessary in the order the sequence they run
Am I right ?

Pierre.

dsexport.exe to export individual jobs,
dscmdexport.exe to export whole project.

Well,

That's exactly what I needed (I should have test it before, mea culpa...).

Thanks very much, Craig.

Pierre.

Hi all, I explain the problem I'm facing : I have a batch that executes the following commands : - list all projects in a file (%DirDSBinLong%dsjob -server %DSHost% -user %DSUser% -password %DSPass% -lprojects > %ListProj%) - read %ListProj% - - list all jobs of the current project (%DirDSBinLong%ds...

Now, we know you get an error, but we don't know which error.
What is your error message ?
What is the difference between "earlier" and now ?

I'm afraid there is no way to do that...

Yes,

Usage of shared containers makes maintenance easier (i.e when you change a file format or alter a table), and reduces error risks.
As Miwinter noticed, you just have to recompile jobs after a change.

I don-t see any reason to unuse it.

Pierre.

Can you describe the result you expect ?

I mean, if today is 2009-01-07 and previous date is 2008-12-06, do you expect 1 or 2 months ?
And if today is 2009-01-07 and previous date is 2008-12-08, do you expect 0 or 1 month ?

And so on...

Pierre.

Hi, I have 3 parameters in routine and i want to use these params to use inside routine. 3 params: src dir , filename , tgt dir My expectation: Move c:\ak.txt c:\tgt\ srcdir = c:\ filename = ak.txt tgtdir = c:\tgt I want to make use of this command MOVE and wanna move the files. Please post the exa...