November 10, 2005 at 1:58 pm
I don't know if this is the correct forum for this question, but here goes.
I have the need to take a text file, covert it to a .csv format and add a character seperater at the end of each record then FTP the output to a Vendor.
Does this sound like a job for DTS package or am I going to have to start brushing up on my programming skills?? not sure how to proceed ???
November 10, 2005 at 4:35 pm
Is it once or on a regular basis?
Also, what is a record format now? Do you need to add commas?
I would say it is a VBscript task, but again you may use VBscript inside DTS if you need to do it every day
Regards,Yelena Varsha
November 11, 2005 at 2:32 am
I am not so familiar with VBscript but have made something similar in VB 6.
The script can read a text file with a user defined field and row delimiter
and print out a file with a user defined field delimiter like a , (row separator CR/LF. The script doesn't store the text file (but each row) in an variable (it can be a big file and the script is fast. Then the file can be sent by FTP using the component msinet.ocx.
if intersted I can give you more details.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply