GPSPOW
asked on
Passing dataset name to stored procedure
I have a stored procedure that requires an "xml" file as its dataset. I have attached the stored procedure text and a picture of the directory where the "xml" file is located. When I execute the query to run the stored procedure I get an error that the file does not exist.
Here is the query I am executing:
execute livedb.dbo.mt_pr_2016Spec_ eCQMImport ValueSetDa ta
'C:\Documents and Settings\gpowers\My Documents\eh_only_unique_v s_20170106 .xml';
Can you tell me why the procedure does not recognize the file?
thank you
Glen
xml-file.jpg
ImportProcedure.txt
Here is the query I am executing:
execute livedb.dbo.mt_pr_2016Spec_
'C:\Documents and Settings\gpowers\My Documents\eh_only_unique_v
Can you tell me why the procedure does not recognize the file?
thank you
Glen
xml-file.jpg
ImportProcedure.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
Once I ran it from the server where the procedure was housed and moved the dataset to a public server it worked.
Glen
Once I ran it from the server where the procedure was housed and moved the dataset to a public server it worked.
Glen
ASKER
thanks