Global Variable in DTS

Last Post 19 Apr 2006 10:05 AM by websiteguy. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

19 Apr 2006 10:05 AM
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 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.

Acceptable Use Policy