I am really hoping someone can help me with this. I have been trying for a couple of days now and can't figure out how to get it to work.
I have a vb.net script that gets a variable (path to Access db that i want to import into SQL Server) from a form on a previous page. I saved the import as a stored procedure. I know how to pass the global variable back to SQL Server but cannot figure out how to set the global variable as the data source in my stored procedure. Can anyone help me out?
Thanks in advance to anyone who can help me out.