Best alternative to VB Script

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.

Reply to
Ashutosh
Loading thread data ...

Its up to you to clean your data and perhaps your not as skilled as doing so requires. Regardless, you want to learn about Microsoft's PowerShell. VBScript is and will remain the preferred scriping language for system administration. PowerShell is the latest incarnation and is looking real good these days...

Hi All,

Reply to
clintonG

PolyTech Forum website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.