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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-10-07 : 12:07:43
|
| How can I call a stored procedure from vb script..because from DTS iam writing a script say 213433/tytty.xls.Now the first part is the emp_id and the second part is the desc and the third is the extension.Now using split function I could split them.Now I need to store them in table in emp_table of EM database .This Xls file is in a shared drive..I was able to get the split and all working but calling stored procedure to store the values in the table was giving problem..i was trying with execute usp_emp_splitter @filename in vbscript of the DTS |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-10-07 : 23:45:31
|
| IS it possible to get output parameters from a DTS un and use them in the stored procedure.Please help me to solve this issue |
 |
|
|
dasu
Posting Yak Master
104 Posts |
Posted - 2004-10-08 : 06:23:35
|
| if u want execute stored procedure from dts u need to follow this1.u have to populate global variables with the values u got from split task2go for disconnected edit3select specific sql task 4 click on input parameters and enter global variables in double quotes separated by semi colan.5.now ecxecute it u will get what ever u wantany doubs let me knowreagardsdasu.g |
|
|
|
|
|
|
Stored procedure in DTS