DSXchange

Ok..So I have a typical problem, which am not able to pass through may be someone can help.

I have a sequence for the jobs and its parameterised.
I have 2 sets of parameters, 1 for sources and the other for the target DB's and connection details, which includes the parameters for DB's, schemas, DSN etc.

Now, when I run the sequence, which say point to/from DB_1, randomly it will generate error Error calling DSSetParam(Pset.DB_X), code=-3 [ParamName does not reference a known parameter of the job]

so, it refers to some other DB and says its not being used in the job. and ABORTS.

If I run the jobs individually then its fine, but with sequence it will ABORT.

Can please help me an insight on it. Thanks.

How Do You pass the parameters to the jobs?

Do the jobs use the same parameter-sets? Or do you pass the parameters from the parametersets to individual job-parameters one by one?

Did you change the parameter-set after you last compiled any of the jobs?

I guess Compile was the trick..I just compiled my all the jobs, and am running the Sequence now, I hope its a success. Thanks