since no one did answer me yet, I conrinue my research and found the following answer:
instead of using the macro command runapp I used the event procedure function
shell then I concatenate all the comand string in a variable that i called by the shell function and it works verry well. The codes became as follows:
dim getvar, var1
var1 = "C:\program files\microsoft sql server\80\Tools \Binn\dtsrun.ex e /S (local)...
ewehbe
Last Activity: Dec 8 '06, 02:24 PM
Joined: Jul 10 '06
Location:
-
since no one did answer me yet, I conrinue my research and found the following answer:
instead of using the macro command runapp I used the event procedure function
shell then I concatenate all the comand string in a variable that i called by the shell function and it works verry well. The codes became as follows:
dim getvar, var1
var1 = "C:\program files\microsoft sql server\80\Tools \Binn\dtsrun.ex e /S (local)...Leave a comment:
-
sending a parameter from an access database to a DTS package in sqlserver
I am trying to call this command from an access data base through RUNAPP macro commande:
"C:\program files\microsoft sql server\80\Tools \Binn\dtsrun.ex e" /S "(local)" /N "mypackage" /E /A mydate:8 = "Forms!Opensitu ation!Combo4"
mypackage: is the name of the dts package in sqlserver
mydate is the name of the global variable used in sql server
8 is the string type... -
sending a parameter from an access database to a DTS package in sqlserver
I am trying to call this command from an access data base through RUNAPP macro commande:
"C:\program files\microsoft sql server\80\Tools \Binn\dtsrun.ex e" /S "(local)" /N "mypackage" /E /A mydate:8 = "Forms!Opensitu ation!Combo4"
mypackage: is the name of the dts package in sqlserver
mydate is the name of the global variable used in sql server
8 is the string type...
No activity results to display
Leave a comment: