Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-23 : 07:25:26
|
| xhz writes "I´ve Access as User Interface and SQL-Server as Database. How can I run a DTS (with global variables) from Access?" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-23 : 08:30:46
|
| You can call a comand line from inside access and use.(from BOL)dtsrun [/?] |[ [ /[~]S server_name[\instance_name] { {/[~]U user_name [/[~]P password]} | /E } ] { {/[~]N package_name } | {/[~]G package_guid_string} | {/[~]V package_version_guid_string} } [/[~]M package_password] [/[~]F filename] [/[~]R repository_database_name] [/A global_variable_name:typeid=value] [/L log_file_name] [/W NT_event_log_completion_status] [/Z] [/!X] [/!D] [/!Y] [/!C]]However I would not do this I would recreate the DTS into its own Stored Procedure which you can call via form association.JimUsers <> Logic |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-23 : 12:07:32
|
| I've got a 38...can anyone tell me how to play russian rouletteBrett8-) |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-23 : 12:16:15
|
| 1st put a round in each chamber...........JimUsers <> Logic |
|
|
|
|
|
|
how to run a DTS from Access