External Source stage
Moderators: chulett, rschirm, roy
External Source stage
Hi,
i am using the external source stage for two different things.
1.to extract the XML file(using ls command)
2.to get the file/dataset count.(using dsrecords function)
But i am getting the errors like this.
Error occurred during initializeFromArgs().
<External_Source_1> Invalid data source specified: Invalid hostname: dsrecords E.(here file is in E drive)
Creation of a step finished with status = FAILED.
Can anybody look at this and give me the solution for the above mentioned two scenarios
Regards,
vasu
i am using the external source stage for two different things.
1.to extract the XML file(using ls command)
2.to get the file/dataset count.(using dsrecords function)
But i am getting the errors like this.
Error occurred during initializeFromArgs().
<External_Source_1> Invalid data source specified: Invalid hostname: dsrecords E.(here file is in E drive)
Creation of a step finished with status = FAILED.
Can anybody look at this and give me the solution for the above mentioned two scenarios
Regards,
vasu
VASU..
![Idea :idea:](./images/smilies/icon_idea.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: External Source stage
Are you using dsrecords function to get the count from the file
I thought this function only relates to DataSet
.
![Confused :?](./images/smilies/icon_confused.gif)
![Question :?:](./images/smilies/icon_question.gif)
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Ping me if I am wrong...
i am using for each(dataset count and xml file extract) operation different external source stage.
********************
My syntax is like this for xml extract using external source stage
Source Method=Specific Programs
Source program=ls #XMLFilePathName#/#XMLFileName#
And Format tab
Final delimeter=end
and column is xmldoc vachar 2000
In xmlinput stage i have selected the option as XMLDocument.
***********************
For dataset count
Source program=dsrecords #FilePathName#/#FileName#.ds
**************
Please check the above options i have set and correct me if i am wrong.
********************
My syntax is like this for xml extract using external source stage
Source Method=Specific Programs
Source program=ls #XMLFilePathName#/#XMLFileName#
And Format tab
Final delimeter=end
and column is xmldoc vachar 2000
In xmlinput stage i have selected the option as XMLDocument.
***********************
For dataset count
Source program=dsrecords #FilePathName#/#FileName#.ds
**************
Please check the above options i have set and correct me if i am wrong.
VASU..
Does it work when you hard code the values?
Exactly what values are you using?
Ernie
Exactly what values are you using?
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Right...can you send us the exact values that you are using that fail. thx.
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom