DSXchange

Instead of adding \ to the line break in the query, could you try to adding APT_OSL_PARAM_ESC_SQUOTE as a User Defined variable for your project or in the specific job parameter while setting its value to "\" without quotes ?

Here is my design. Execute_command --> UserVariable --> StartLoop --> Job_Activity. EC runs the ls abc*.txt UV runs Field(Convert(@FM, ",", Execute_Command_0.$CommandOutput), ",", 1, Count( Execute_Command_0.$CommandOutput,@FM)) SL uses the output of UV as counter JA has 2 input ...

Excellent. That works. Thank you, chulett.

But how do I populate UserVars.var1 and UserVars.var2 from the file name coming out of the start_loop_activity.counter?

Darn... As always, you are right Sir Wurlod. It works fine now. thank you very much. By any chance do have any suggestion on how I can do the following in a sequencer? - Run the following ls command in the execute command stage. {DONE} ls abc_123_US_*.txt. - If it fetches any file then convert the e...

In the user variable stage,

Field(Convert(@FM, ",", ExecCommand.$Output), 1, Count(ExecCommand.$Output,@FM))

In the execute Command stage,

grep -L root #Src_file#*.txt

I also tried ls #Src_file#*.txt

Ray and Chulett - Thank you. But when I use Ray's command the output is basically the number of files that the ls command is fetching. It is not giving the actual file names. E.g. if my ls command lists abc.txt def.txt Field(Convert(@FM, ",", ExecCommand.$Output), 1, Count(ExecCommand.$Out...

I tried ls -m but it doesn't work on Windows Power Shell or command prompt. I simply want to loop the sequencer as many times as I have the number of files in the directory. The grep command lists the file names correctly but I am not able to give a new line character as the start loop delimiter. e....

Hi, I am trying to build a sequencer to get a list of files from windows server and loop them in 1 by 1. Execute Command --> Start Loop ---> Job Activity --> End Loop In the execute command, I am executing the following command to give me the list of file names in the directory. grep -L root #Src_fi...

Actually, when I tried to give "ls C:\TEST.xml" without quotes, I get the following error. The source method is Program Files External_Source_31: Could not open source list file "ls C: est\dim_Item-TEST.xml" should I give it in quotes? {EDIT}: The path I give is "ls C:\XML\T...

Hello Eostic,
I did read your post with the title "Reading XML Content as a Source".

Are you suggesting to use unix ls command on Windows system which is my OS? If so, I tried that too.

Thank you, Guys. But I am definitely doing something wrong as I still can't make it work. Here is what I did. - Imported the XML file into XML Table definition. In the XML Meta Data Importer window, I expanded all the sections. Under "Records", there was "R" and under that there ...

Thank you, Chulett. I did download the Best practices doc from Ray's website and I am reading it now. Here is an update on my issue (and it still exists :( ) Got the XSD file layout and imported to the XML definitions as Ray suggested. Then used External Source--> XML Input --> Peek design to proces...

Excellent. Thank you Ray. I will give it a shot tomorrow and update this thread with the results.

Chulett -Thank you very much for the information. No, I have never done anything with XML files before. The design that you proposed is exactly what I have in my job design. But I was not aware of the XSD file. I will get that as the first thing from the vendor sending this file and see how it goes....