Hi All,
I am a newbie to VBScript. I have a script that copies files from remote server to local drive and then bulk inserts the data into database by parsing the local file. Sometimes the data contains garbage characters so bulk insert fails and i have to manually edit the contents and re run the script. Is there any tool or the language through which i can automate the manual process of error detection and correction mentioned above?
Thanks in advance!
-Ashutosh.