| Author |
Topic |
|
sippon77
Starting Member
13 Posts |
 Posted - 2005-12-02 : 09:30:17
|
| Hi,I need to regularly upload files to an existing directory structure through DTS using AspUpload utility as this is being currently used when i upload file from the front end (gui) of my application.How can this be done?Can we use ASPUpload utility through DTS.Thanks in advance.rgds,siva |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-04 : 07:46:37
|
| What type of file are u looking to upload ?excell or access or just csv ?afrika |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-12-04 : 22:40:53
|
| I guess it should be possible using an ActiveX Script.Karunakaran |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 01:18:03
|
| See if you find scripts here www.sqldts.comMadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-05 : 03:54:53
|
| Nice site and scripts, MadhivananHOwever sipppon77 didnt say what file types are being uploaded |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 06:14:17
|
quote:
Originally posted by afrika
Nice site and scripts, MadhivananHOwever sipppon77 didnt say what file types are being uploaded
Yes. That is specifically for DTSMadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-05 : 11:42:05
|
| Once again, wonderful article/site |
|
|
|
sippon77
Starting Member
13 Posts |
Posted - 2005-12-06 : 08:18:25
|
| It could be any kind of file ,txt,xls,csv... They get copied to a file serverAnd i need to use the existing ASPUpload utility. This is because ASPUpload copies files randomly to a directory structure on your file server. Since we are using this in the front end i would want to use the same when i do it through the DTS. |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-12-06 : 09:16:29
|
| Did you try to create an object for ASPUpload in your ActiveX Script task? then you can use that object to upload the files right?ThanksKarunakaran |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-06 : 14:58:32
|
| we implemented such a similar solution for our phonebook in excell and dundas upload utility.we first did and upload, and then a script that reads the excell worksheet and displays a prompt for the user. upon confirmation, it runs a dynamic sql script which does an insert into the phone book tableafrika |
|
|
|
|
Use ASPUpload through DTS