Execute MSSQL-batchjob through ADO

[Morten Snedker]

I wish to save a DTS-package that imports a text file to a table. This
saved DTS-package should be executed through ADO. Is this possible -
and if yes: how?

Thanks in advance for your effort and input.


Regards /Snedker


x-post:
microsoft.public.access.modulesdaovba.ado,microsoft.public.access.modulesdaovba
fut: microsoft.public.access.modulesdaovba.ado

 

[Douglas J Steele]

I don't believe it's possible.

ADO is a generic access method to query data. DTS is an application-specific
interface.

 

[Robert Morley]

Like Doug, I can't see any way of doing it from ADO. Your best bet would
either be to run it from Visual Basic, or using the DTSRun command from the
command line. See the SQL Server help file under "executing DTS packages"
for help with either of those methods.


Rob

 

[Dave Patrick]

Also take a look at SQLDMO

http://msdn.microsoft.com/msdnmag/issues/01/05/sqldmo/

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I wish to save a DTS-package that imports a text file to a table. This
| saved DTS-package should be executed through ADO. Is this possible -
| and if yes: how?
|
| Thanks in advance for your effort and input.
|
|
| Regards /Snedker
|
|
| x-post:
|
microsoft.public.access.modulesdaovba.ado,microsoft.public.access.modulesdaovba
| fut: microsoft.public.access.modulesdaovba.ado