DSXchange

chulett wrote:What stage are you using? What does the documentation for that stage list as unsupported data types and/or as 'issues' for the stage? ...

I'm using 'SQLServer Enterprise' Stage for extracting the records.

Documentation for this stage doesn't give any information about the unsupported data types.

When i was trying to extract column from a table mounted in SQL-Server 2005 database, I was getting the following error, Error executing View Data command:##E IIS-DSEE-TDOD-00001 10:41:44(007) <main_program> Datatype Not Supported ##E IIS-DSEE-TDOD-00001 10:41:44(007) <main_program> Datatype Not Sup...

chulett wrote:OK, nevermind on the codepage. You've got a hex value, what are you expecting in the sequential file? That same value or do you need to... 'decode' it? ...

I'm expecting the same value in the file.

chulett wrote:Just looks like it may be a codepage / character set issue. Can you post an example of this "binary" data? ...

Below is an example value for one of the binary field,

0x0000000000326839

Hi, I cereated the below routine with the name 'GetJobSequencerName' $include DSINCLUDE JOBCONTROL.H JobName=Arg1 JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL) controllerList=DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER) ErrCode=DSDetachJob(JobHandle); print controllerList; Ans=controllerList Called i...

Hi, I cereated the below routine with the name 'GetJobStatus' $include DSINCLUDE JOBCONTROL.H JobName=Arg1 JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL) controllerList=DSGetJobInfo(JobHandle,DSJ.JOBSTATUS) ErrCode=DSDetachJob(JobHandle); Begin Case Case controllerList = 1 Ans = "Finished"...

[quote="subrat] Could you try with the below macro and check if its working fine.... $include DSINCLUDE JOBCONTROL.H JobName=Arg1 JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL) controllerList=DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER) ErrCode=DSDetachJob(JobHandle); print controllerList; Ans=co...

I was using the following code in the column derrivation of my server transformer to get the job status, DSGetJobInfo(JobName, DSJobStatus) but it was not reuturing any value. Please help me in achieving it. I've list of jobs avaialable in the project in a spreasheet as like below, Job1 Job2 Job3 Jo...

Or, as noted, the DSJobController macro can be used just like a job parameter. Got a chance to look it up. :wink: ... When i try placing this value in the column derivation of my tranformer DSGetJobInfo(JobName,DSJ.JOBCONTROLLER) I was getting -1 as output. I was not getting the Sequencer name as o...

Or, as noted, the DSJobController macro can be used just like a job parameter. Got a chance to look it up. :wink: ... When i try placing this value in the column derivation of my tranformer DSGetJobInfo(DSJ.ME,JobName) I was getting -5 as output. I was not getting the Sequencer name as output. :cry:

ArndW wrote:The DSGetJobInfo(YourJobHandle,DSJ.JOBCONTROLLER) will give you a job's parent. ...

Thanks ArndW,

But how u call this function in server transformer....

Hi Gurus, I've a list of jobs in a sequential file. I want to get the Sequencer name at which these list of jobs are being called. How to achieve it by using Server routines... Sample input & output are given below, Input: Job1 Job2 Job3 Job4 Output: Job1 Seq1 Job1 Seq2 Job2 Seq1 Job3 Seq1 Job4 ...

Hi Gurus, I have been asked to create a job to generate job statistics report of all the jobs available in the prodcution environment. My report should have the values as below for all the jobs in production, Sequencer Name Job Name Start Name End Time Records read from source (optional) Records Wri...