dbTalk Databases Forums  

how to build a DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss how to build a DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ricky
 
Posts: n/a

Default how to build a DTS - 06-21-2006 , 02:54 PM






Hi

Can somenone help me build a DTS in SQL Server 2000 that allows to schedule
the execution of a executable file in a remote server?...

[]
Ricky



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: how to build a DTS - 06-22-2006 , 01:09 PM






Hello RICKY,

Why do you need to do this in DTS? In DTS you are going to call the executable
in a ExecuteProcess task or you could call it from the command line.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
Hi

Can somenone help me build a DTS in SQL Server 2000 that allows to
schedule the execution of a executable file in a remote server?...

[]
Ricky



Reply With Quote
  #3  
Old   
Ricky
 
Posts: n/a

Default Re: how to build a DTS - 06-22-2006 , 08:39 PM



Yes, you're right. But at command line i've already test it and doesn't work
with the windows schedule (command AT). So i've remember i don't make this
schedule in SQL Server 2000 with a DTS once the database of TrackIT from
intuit works in SQL Server.

Can you help me making a shedule DTS that calls the Trackit audit 'exe' in
the remote server at a certain time of the day/week?..

Thanks
Ricky


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
Hello RICKY,

Why do you need to do this in DTS? In DTS you are going to call the
executable in a ExecuteProcess task or you could call it from the command
line.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi

Can somenone help me build a DTS in SQL Server 2000 that allows to
schedule the execution of a executable file in a remote server?...

[]
Ricky





Reply With Quote
  #4  
Old   
Ricky
 
Posts: n/a

Default Re: how to build a DTS - 06-25-2006 , 07:09 PM



Hi

The purpose is to schedule a file "audit32.exe" from (Trackit Enterprise)
www.itsolutions.intuit.com that will run at a certain time/day in remote
servers to audit them.

I've already try with the windows schedule but didn't run well once not
always the audit were well done and not always it run. This test was done at
command line calling the AT command.

What do you advice now?..
[]
Ricky

Quote:
Why do you need to do this in DTS? In DTS you are going to call the
executable in a ExecuteProcess task or you could call it from the command
line.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
Hello RICKY,

Why do you need to do this in DTS? In DTS you are going to call the
executable in a ExecuteProcess task or you could call it from the command
line.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi

Can somenone help me build a DTS in SQL Server 2000 that allows to
schedule the execution of a executable file in a remote server?...

[]
Ricky





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.