DTS and VB????

[Maniivannan]

I need to pump a huge amount of data, some 200 tables (and its attributes
too) to SQL Server and after that i need to transfer the same data to text files
and excel files. i know we can use DTS for this, this is not an one
time job, so i want to use vb application to automate this ...like
calling the DTS as an object into vb application...or please tell me
will it work or is there anyother possibilities..????

[anantapantula]

Hey You can Schedule the Package which will be helping you alot in doing something Like automated.