RE: DTSRun Call from Unix

sshaahin, Darren Green from www.sqldts.com states in one of his webpages:

"There are two main methods of executing a DTS package from within T-SQL,
either using the DTSRUN utility to perform the execution, or going through
the DTS object model".

"DTSRUN is a command line utility for executing packages. This can be called
from within T-SQL using the xp_cmdshell extended stored procedure. Both are
fully documented in SQL Server Books Online. If you have trouble building the
command line a quick tip is to use the Schedule Package option (Right-Click
the package in Enterprise Manager). This creates a SQL Server Agent Job, from
which you can extract the generated command line string. If you have SQL
Server 2000 then the DTSRUNUI utility has a Generate function, amongst the
advanced options."


In Unix you can use cron(a daemon process), which only needs to be
started once. A SQL file can be written that calls the above xp_cmdshell
stored procedure. This SQL file is called from a shell script and this script
is scheduled using cron. This is how a job is scheduled in Oracle running on
UNIX.




"sshaahin" wrote:

> Need to execute DTSRun from a Unix box (no dos partition). Any ideas?
>
> Thank you in advance.
.

Relevant Pages

  • Re: New schedule DTS job always failed
    ... The owner of the package has very very little to do with anything where executing a package is concerned. ... I added new DTS in SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS package fails to execute from scheduler
    ... Because you are not executing the package as you. ... Now that might be a Windows question not SQL server. ... It would seem that the package fires from the scheduler so we are ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS package fails to execute from scheduler
    ... No I am talking about inside the package itself. ... It would seem that the package fires from the scheduler so we are actually ... executing. ... This is the first time I've am scheduling an SQL Server 2005 package. ...
    (microsoft.public.sqlserver.dts)
  • dtsrun fails inside a job
    ... I created a dts package and it seems to work well when i execute it ... But when I use the dtsrun utility to run the ... edit the package....the server where i am storing this package is sql ...
    (microsoft.public.sqlserver.security)
  • Re: Millions of Delete Statements
    ... You mention a cursor. ... Others have mentioned batching the commands, ... so I will throw out one that is less good (executing them ... get the whole SQL statement I don't know of another way to do it). ...
    (comp.databases.ms-sqlserver)