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
 General SQL Server Forums
 New to SQL Server Programming
 Pass xml file to stored proc from bat file

Author  Topic 

JeffT
Posting Yak Master

111 Posts

Posted - 2008-03-18 : 10:53:11
Hi,

I'm having trouble with the syntax for passing a file to a stored procedure via a batch file. What I have so far is below (should it be something like this (with quotes included) 'c:\MyXMLFile.xml' ??):

osql -U%USER% -P%PASSWORD% -S%SERVER% -d%DB% -b -Q"set nocount on exec usp_stored_proc <here is where I want to specify the .xml file name>

Thanks,
Jeff

   

- Advertisement -