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 - 2004-01-16 : 07:59:30
|
| pughal insuvai writes "scheduling to export sql table into text files daily using sql queries.the problem is we want to execute the process daily by getting the required parameters from the user.for example :sql query is select eno,ename,deptno from employ where deptno=?.ie it will exectue based on the given deptno.problem:it won't ask the parameter value deptno" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-16 : 08:02:16
|
| Scheduling a DTS package that requires user input is not a good idea, the machine will hang. You can pass parameters to a DTS package if you're using SQL Server 2000, look at the /A paramter under dtsrun.exe (in Books Online) You can also write a small ActiveX task to prompt the user for a value, but again this cannot be used if the job is scheduled. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2004-01-16 : 12:42:34
|
| What about giving the user the ability to populate a table and pull those parameters from the table as they've specified. I've done something like this in the past for a job server that worked nicely.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
SQL-DTS