error on reading vb script generated csv file

egsalayon · Post by **egsalayon** » Mon Apr 16, 2012 7:15 am

Hi,
We have multiple repeating (example would be a monthly report) excel files are sources. Instead of creating a DSN each time a new excel source, I created a vb script that would dump data into a csv file. I set the sequential file option/property 'Record Delimiter String' to 'DOS format'. But when I tried viewing the contects of the file, it encounters error:

Consumed more than 100000 bytes looking for record delimiter.

Hope you could help me on this, many thanks and more power...

Regards,
Eric

ray.wurlod · Post by **ray.wurlod** » Mon Apr 16, 2012 2:57 pm

You'd better tell us what the error is, since the record delimiter in this file clearly is DOS-style.

egsalayon · Post by **egsalayon** » Mon Apr 16, 2012 8:41 pm

Hi Ray,

Thanks for the reply.

ray.wurlod wrote:You'd better tell us what the error is, since the record delimiter in this file clearly is DOS-style. ...

I mentioned the error in the first post which is:

"Consumed more than 100000 bytes looking for record delimiter. "

I am including the screenshot of the error:

Screenshot of the Record delimiter property in sequential file stage:

Sorry, I need to remove the screenshot of the vb script generated CSV file since its data is confidential..

Regards,
Eric

chulett · Post by **chulett** » Mon Apr 16, 2012 8:52 pm

Don't see anything obviously wrong... what exact 8.x release is this?

egsalayon · Post by **egsalayon** » Mon Apr 16, 2012 9:15 pm

Hi Craig,

Version is 8.5 fixpack 1

Regards,
Eric

qt_ky · Post by **qt_ky** » Mon Apr 16, 2012 10:21 pm

Any chance there are extra characters hiding after CR/LF?

egsalayon · Post by **egsalayon** » Mon Apr 16, 2012 11:25 pm

Hi Eric,

qt_ky wrote:Any chance there are extra characters hiding after CR/LF?

None

kandyshandy · Post by **kandyshandy** » Tue Apr 17, 2012 1:23 am

how does data look when you open with Textpad or UltraEdit?

egsalayon · Post by **egsalayon** » Tue Apr 17, 2012 2:15 am

kandyshandy wrote:how does data look when you open with Textpad or UltraEdit?

What I use to view the file is Notepad++ and when I set the option View->Show Symbol->Show All, no extra character except for the CRLF which is the Carriage Return and Line Feed characters.

Will install Textpad for the checking you requested.

Does anyone here taken the same as route as mine:

Excel File-->Processed by VB Script-->Output to CSV/Text File

I think its the VB Script has putting extra characters, just my observation now

egsalayon · Post by **egsalayon** » Tue Apr 17, 2012 4:51 am

Hi,

Our hunch is correct, it is on the creation of the csv file on vb script. Need to set to encoding to ANSI.

Thanks for all who provided insight and time in this inquiry..

Best regards,
Eric

DSXchange

error on reading vb script generated csv file

error on reading vb script generated csv file

Solved: Setting of Encoding in the vb script was set to ANSI