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 |
|
yamravi
Starting Member
2 Posts |
 Posted - 2003-05-27 : 06:09:23
|
| Hi allcan any body help me as i am in very critical condition.How to execute the indiviual data task transform from VB/VBscript Example: every day i will get 2000 flat files from different branches(hkg,tky,sng..etc) which will be stored in different local directoryI have created a different sql/execute package this can be triggered if the user wants to import all the 2000 files one time well this works.My problem is if user wants to execute only one task(data task transform)i.e only one file at a time how to write a program to execute just user selected task and dump the files in to desired location.many many thanks in advanceyamravi |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-27 : 07:12:15
|
| Hi yamravi!Have you tried the task.Execute method in the object library? |
 |
|
|
yamravi
Starting Member
2 Posts |
Posted - 2003-05-27 : 11:05:36
|
Thanks for your repley.I tried this but in vain can you send me one small examplethanksquote:
Hi yamravi!Have you tried the task.Execute method in the object library?
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-27 : 12:35:49
|
| You said that you have tried this, but what error did you get? We need to understand what you have already tried. Also, why are you doing this in DTS? Can't you just create a custom program for them outside of DTS?Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-27 : 14:55:47
|
quote:
Hi allcan any body help me as i am in very critical condition.
I'll call the doctor! Why not create a configuration table instead and use bcp's from a stored proc?Brett8-) |
|
|
|
|
|
|
DTS