troubleshooting Question

SQlvss

Avatar of vikasbapat
vikasbapat asked on
ProgrammingASPVB Script
7 Comments1 Solution201 ViewsLast Modified:
Hi All
This command works fine from the command line:

C:\>type "C:\VisualSS\SQLCode\R-18_SQLEXPRESS\emp\RunLog5-29-2008 1-00-46 PM.Log" >> "C:\VisualSS\SQLCode\R-18_SQLEXPRESS\emp\RunScriptLog5-29-2008 1-00-46 PM.Log"

But the same command when i run with following script give VBScript compilation error  

' ********************************************
Option Explicit
Dim WshShell
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run "command.com /k " & type "C:\VisualSS\SQLCode\R-18_SQLEXPRESS\emp\RunLog5-29-2008 1-00-46 PM.Log" >> "C:\VisualSS\SQLCode\R-18_SQLEXPRESS\emp\RunScriptLog5-29-2008 1-00-46 PM.Log" 'run DOS commands
Set WshShell = Nothing
 
I don't know what is going wrong. I want to copy the contain

"C:\VisualSS\SQLCode\R-18_SQLEXPRESS\emp\RunLog5-29-2008 1-00-46 PM.Log"  

into

"C:\VisualSS\SQLCode\R-18_SQLEXPRESS\emp\RunScriptLog5-29-2008 1-00-46 PM.Log"




Thank in Advanced
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros