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 |
|
pfechner
Starting Member
2 Posts |
 Posted - 2005-07-01 : 05:43:31
|
| Required steps 1.Copy all xls files from folder(a) to folder(b). 2.For each file within folder (a): (1)import the data using BCP into a table then (2)pass the current filename as a parameter to a stored procedure and execute it (3)delete the current file (4)loop back and perform the above steps against the next file |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-07-01 : 05:49:57
|
| Where you have problem? You can do this with activex script inside dts. I think some body might come up with a alternative approach using T-Sql.Karunakaran___________http://spaces.msn.com/members/gotdotnethttp://spaces.msn.com/members/karunakaran |
 |
|
|
pfechner
Starting Member
2 Posts |
Posted - 2005-07-01 : 07:01:58
|
| Definately would prefer an ActiveX script within DTS. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-01 : 10:51:20
|
| so what do you want?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
|
|
|
|
|
|
DTS look @ files executing sp against each one