DSXchange

loveojha2 wrote:You can use Microsoft's ODBC Driver for Excel for this.

But I would prefer to do it by converting it into the csv then using using the csv as a sequential file.

Is there any other way, leaving this ODBC and Converting into CSV.

Hi,

How to import excel file and need to convert excel file data into table. Thanks in advance.

Hi all,

how to pass the file name dynamically to sequential file stage. Thanx in advance

Hi all,

can we pass parameter values dynamically(without human intention). If s pl tell how to do that. Thanx in advance.

Welcome aboard :) The File Name is SDKSequences. You can see it being used within the Routines KeyMgtGetNextValueConcurrent and KeyMgtGetNextValue. This file maintains the sequences. Where i can get that file. See like i am passing a value as 1. at target it generate seqnumber from 1 to 10. This se...

Hi all,

I need to find the file which is tracked by datastage when we generate seqnumber by using keymgt. Datastage keeps track of seqnumber in a file whenever it generates. Thanx in Advance.....

ArndW wrote:You need to start by looking at the documentation.

The DataStage Designer guide to begin with and search for "mail".

There are many ways to do this, either directly in a sequence or via a routine call to DSSendMail()

I need to nofity to mobile. How to do that

Hi all,
I need to know hoe to send notification about job failure on mail and mobile.

Hi,

Tell me, where it is preferred to have IPC stage and where it is preferred to have Link Partioner & Collector stage.