DSXchange

Of course. Get the DSN created on the Server machine and give it another shot. [/b] but craig the issue is that we do not have access at all to the server machine.None of the team members have access to the server.So i guess in that case the requirement will not be achievable with this constraint. ...

Just type it in - you are not forced to use the drop-down. From what I recall, it won't show up on that list until you import metadata using it. I tried typing in the DSN Name but it doesnt work because i guess the DS Server engine and the DSN needs to be on the same machine.My Current Environment ...

Unless you can use ODBC you're screwed. It's the only way you can access worksheets in an Excel workbook. And even then they're system tables. Get someone to create the DSN for you. ... Thanks for the help Ray,but the problem is even if i get someone to create a DSN it doesnt Appear in the DropDown...

Hello, I have a DS job in which i use Sequential file stage to produce Excel as Output.Here i use Tab as the text delimiter. Now i have a requirement where depending upon a value say Instance name(column in source) in the Source file i have to write the data on new sheets.i.e i have sorted data Inst...

Prove that it is the Link Collector stage that is generating the error. Document your job design here, surrounded by Code tags so that the layout is clear. For example: SeqFile1 ----- ...[/quote] Hi, Can I paste a screenshot here in this forum. otherwise, "OD_AP_MARKED_NEW_PASS1_LOGIC..[color=...

Hello All, I am getting an error while executing a job. And this error is coming at a Link_Collector Stage. DataStage Job 193 Phantom 2260 Program "DSD.StageRun": Line 617, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage OD_AP_MARKED_...

Why not just extract the blocking information from QualityStage? One extra column. Anything with XA or RA is an original, anything with DA is a duplicate. The work has already been done for you! ... Hey this looks a good solution, But i am not well verse with QS. I have read the help on report and ...

Hi, I know about this logic, but it will not work if I have to compare 5th record with the 1st one. I can only compare it to its previous first.
whereas in actual scenario after sorting there are about 50 - 100 duplicate entries, so ideally i have to check 50th record with the 1st original record

Hello All, I have to do a deduplication of invoice records coming from Accounts Payable. The thing is after all cleansing and passing it through Quality Stage, Finally we have to mark the records as Original or Duplicate. So I need to compare the record with all other records. So I wanted to ask, th...

A job was running in Unix. The specific process corresponding to that job was killed to stop that job. Process got killed. But its still showing Status as Running. Job even can't be compile. Please suggest. Try going to DS ADMINISTRATOR, then click on projects tab, select the project name...and the...

What you execute "ls -l" from Execute command activity? Else you need to use DIR with the file name, and the output need to be parsed. I dont find any straight fwd simple method as of now. ... The "ls -l " command is for UNIX box, I think, Rather with the help of your post i rat...

Hi All, it is possible to remove the duplicates using sort stage in server jobs? Thanks in Advance Malli If you can use a Hash File, then declare the primary key..and the hash file will take care of it... But please note that for any duplicate entry, the hash file will retain the last entry in the ...

If you have MKS tool kit installed, you can use "ls -l" command and grep for the time porting and check if the file is for the current "date", if so you can process it. You can acheive this using Exe ... How can i find MKS tool kit...as i don't know about it. Also since our DS i...

Hi All, We are using a folder stage to read som error logs that we generate using DS. Now we have a scenario where we want to check the date modified of the error logs, and if the date is latest then read the file else generate a report. So is there any way in which we can capture the date modified ...

Is it like DS supports a particular version of DOS No, it just leverages whatever it is you got. Post your command. ... Hi, I am using the command as cd\ FIND /N /C "WRI001" c:\Parag\sage_dovegate_inddata_sales_ledger.rpt >> c:\Parag\cmdout.txt here WRIoo1 is the flag value.