DSXchange

Hey Anbu,

I ran Successfully. You are really a Great HELP!!!! Thank You For all Your Support....

Anbu, I modified the sequential file settings so that I am getting SequencerTest1..JobControl (@Execute_Command_12): Executed: cat D:\DataFiles\ETL_DEV_Seq_Files\Policy_MaxModelDate.txt | tr -d '\n' Reply=0 Output from command ====> 2010-05-26 03:34:44 now I got this in sequence job. But still same ...

I think I need to eliminate that ModelDateMax now which is the column name

Hey Anbu,

Now I am getting

SequencerTest1..JobControl (@Execute_Command_12): Executed: cat D:\DataFiles\ETL_DEV_Seq_Files\Policy_MaxModelDate.txt | tr -d '\n'
Reply=0
Output from command ====>
ModelDateMax
2010-05-26 03:34:44

The Director log result for Execute Command is SequencerTest1..JobControl (@Execute_Command_12): Executed: printf $(<D:\DataFiles\ETL_DEV_Seq_Files\Policy_MaxModelDate.txt>) Reply=0 Output from command ====> SequencerTest1..JobControl (@Execute_Command_12): Checkpointed execution of command 'printf ...

I tried Printf Still the same problem exists. Any other suggestions Please

But when I hardCode the same timestamp Value in Sql Sever Stage Its working fine why is that happening?

2010-05-26 03:34:44.450

Yes, I just posted it above. I want to know is my approach to get the timestamp value to a variable correct or not?

I went to the Job Log and Job log is saying this error messge

SQLServer_Enterprise_0,0: [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.

The Second job to which I am passing timestamp is getting aborted. The abort message I am getting in sequence job is

SequencerTest1..JobControl (DSWaitForJob): Job Px_Etl_Unld_Pc_PolicyPeriod_TodaysDate1 has finished, status = 3 (Aborted)

Yes, you are right. I am sorry for posting that warning. The problem is job is getting aborted.

Hi, I Unloaded the max of timestamp in to a text file using sequential stage. I need to pass this as job parameter to next job using sequencer job. For this I used Execute command stage and in the command line I tried 'Cat Textfilepath.txt'. In the next job activity I specified job parameter values ...

I kept all xml files in a shred folder and tried using shared folder. I can get the link out of the External Source Stage and passed it to XML input stage. The job ran well but 0 record are imported. It has only one warning XML_Input_3,0: Warning: XMLTest4.XML_Input_3: XML input document parsing fai...

Craig,

I looked at it. Its really Helpful. I dont why its not working for me. My sever is in D:/, is that the problem. If thats the problem Please tell me a solution.