asp and DTS

[anilcognos]

I have a asp page which sits on one server and SQL Server
is on another machine. So how to run a DTS package from that asp page
Is it possibe, or the asp page and the SQL Server should sit on the same page?



Anil

 

[Tarwn]

DTS?
Digital Theater System?



Sorry for the ignorance, a definition might help me a little

-Tarwn Experts are only people who have realized how much they will never know about a language.
________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924

 

[anilcognos]

DTS is Data Transformation services
in sql server.
you can automate repetitive tasks like loading data from
sources like excel etc
Anil

 

[Falcon99]

If you just need data transformation look into the BCP utility. You can run that from SP.

Else look into DTSRUN. I've never used it but it can be run from a command line, so it has possibilities that it too can run from an SP.

SQL Books Online

HTH