Hi,
Using SQL server 2000 on Windows server 20003.

I need to copy table(s) from one database to another. I have created a Copy
SQL Server Objects Task to do this. However, I need to have a user run this
from Access VBA. I would like to have them input a table name, press a
button and the table copies.

How can I pass a table name as a variable to this task. I have gotten as far
as 'LoadfromSQLServer' etc, but I can't do the rest.

Thanks for any help.

What I would suggest you to do is to create a globle variable in the package
and create a dynamic properties task and have the destination connection
based on that Properties task. In the VBA code add something like

Set pkg = CreateObject("DTS.Package")
Set pkg = LoadfromSQLServer....
pkg.GlobalVariables("YourGlobalVariablesInThePacka ge") =
InputFromUserInTheForm
pkg.execute

it is not too hard, but tough to explain...

Ed

"Tom Swanick" wrote:

Thanks ED,

I'll try it.

"Ed" <Ed (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news:EE109E9A-D312-43F6-8951-B7EA97C2A487 (AT) microsoft (DOT) com...