problem with folder stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 77
- Joined: Tue Apr 14, 2009 4:03 am
problem with folder stage
i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.
Re: problem with folder stage
Check the datatype and the LENGTH of the Column2.kaushal.kumar@igate.com wrote:i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.
RAJ
-
- Participant
- Posts: 77
- Joined: Tue Apr 14, 2009 4:03 am
Re: problem with folder stage
datatype=longNvarchargssr wrote:Check the datatype and the LENGTH of the Column2.kaushal.kumar@igate.com wrote:i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.
Length=999999.
Please advice how to solve this
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: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
Re: problem with folder stage
Are you looking at the ouput or You assume that folder stage reads only one row by the Link count? If later is the case, check your output. Folder stage will always have the link count as 1kaushal.kumar@igate.com wrote:i am using folder stage to read files from load directory. My files are fixed width length file.I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) .but in my job its taking only first rows of file.Please help me what i need to define so that it will take all rows of file.
Arun