error on reading vb script generated csv file
Moderators: chulett, rschirm, roy
error on reading vb script generated csv file
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
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
Last edited by egsalayon on Mon Apr 16, 2012 8:22 pm, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
Thanks for the reply.
"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
Thanks for the reply.
I mentioned the error in the first post which is:ray.wurlod wrote:You'd better tell us what the error is, since the record delimiter in this file clearly is DOS-style. ...
"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
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
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.kandyshandy wrote:how does data look when you open with Textpad or UltraEdit?
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
Solved: Setting of Encoding in the vb script was set to ANSI
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
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