DSXchange

Yeah that was one of my previous test of specifying the whole path without using parameters. I also tried forward and back slashes (\, /) without success.

Chulett - There is no separate field for Path and other Pattern. Everything goes to the same place.

SURA - If I change the Read Method to Sequential File and define any of the files the job process it successfully. Meaning that there is no problem with the file structure.

Hello all. I got this situation in where I want to read two files with the same structure. Test1.txt Test2.txt I'm using Job Parameters to define the fullpath. In the Sequential File Stage in the File Pattern field I define the following: #PathToFile#\Test*.txt When I run the Parallel Job alone I go...

Ok guys this is a solution. In our case we use the product "CA Workload" to schedule all our DataStage Jobs as an internal standard. At the end of the Workload Workflow we added a step that waits for the datastage job that refresh the tables used by Analysis Services to complete. Then we e...

How I can Process an Analysis Service Database using DataStage:?:

I would like to do it after my DataStage jobs load the source tables used by Analysis Services OLAP.



Thank you.