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 |
|
baaul
Starting Member
16 Posts |
 Posted - 2005-11-13 : 12:35:47
|
| I wish to run a program from a DTS task, where a user is prompted for couple of inputs. It's a command line program used for conversion of a file. Here are the cmd line entries:c:\DEDIT SourceFile.bin --User is prompted to enter a command: fil DestinationFilename.asc--Another Prompt to user for (y/n)input: y or nc:\Exit How would I accomplish this? Any help will be appreciated. Thanks! |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-11-13 : 14:43:25
|
| dts is not really there for attended execution.so you would need to write an app to get the params from the user. then pass those on to the dts package yourself (my preferred method is an ini file) and execute it |
 |
|
|
baaul
Starting Member
16 Posts |
Posted - 2005-11-13 : 15:15:57
|
| Is there an example of .ini file prompting for user param?? |
|
|
|
baaul
Starting Member
16 Posts |
Posted - 2005-11-14 : 11:25:42
|
| Hi,Would you have an example app to accept user input params and then passing it to execute process task? I think this is what I would like it to do. User enters the params on some kind of form, and the params are then passed to a DTS package's execute process task param field for execution. Anyone has an example app and the process to follow. Thanks in advance. |
|
|
|
|
|
|
DTS execute process task