Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 why this not work

Author  Topic 

Ali.M.Habib
Yak Posting Veteran

54 Posts

Posted - 2009-06-08 : 06:22:55
I wrote this code to run stored procedure in vbscript file
	WshShell.Exec("osql -S SLM -d SLM_SEB -E -Q ""Exec dbo.storedprocedure1 "" ") 


the stored procedure execute 5 DTS files

why not work corectly

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-08 : 06:40:27
You are supplying an empty string as argument for parameter 1 of stored procedure.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Ali.M.Habib
Yak Posting Veteran

54 Posts

Posted - 2009-06-08 : 06:43:12
quote:
Originally posted by Peso

You are supplying an empty string as argument for parameter 1 of stored procedure.



E 12°55'05.63"
N 56°04'39.26"


Could you give me more details please the stored procderure not take inputs parameters
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-08 : 07:05:16
quote:
Originally posted by Ali.M.Habib

I wrote this code to run stored procedure in vbscript file
	WshShell.Exec("osql -S SLM -d SLM_SEB -E -Q ""Exec dbo.storedprocedure1 "" ") 


the stored procedure execute 5 DTS files

why not work corectly


The underlined part?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -