Need to execute DTSRun from a Unix box (no dos partition). Any ideas?

Thank you in advance.

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:

Thank you for your help, Frank. Our dilemma is that the SQLServer is not
running on the Unix box. It is running on a Windows box. I am looking for
perhaps a shell script that would execute the DTSRun command (or the SQL
file) on the Windows box from the Unix box, and the Unix person should be
able to edit the command, changing the server, user and other parameters
specified in the DTSRun command, without having access to the Windows box.
Your further advice is greatly appreciated.

"frank chang" wrote:

sshaahin, Before we talk about the UNIX shell script, could you please let me
know if you have an ODBC driver such as unixOBDC, http://www.unixodbc.org ,
installed on your Unix machine. By the way, I was wondering whether you are
using UNIX(which OS?) or LINUX(which distribution?)? Thank you.

"sshaahin" wrote:

sshaahin, Because your SQL Server is not running on an Unix machine but
rather a Windows 2000/2003 Machine, you will need an ODBC driver to connect
your Unix machine to SQL Server. Here are some links to commercially
available ODBC driver which may allow you to access SQL Server from UNIX:
http://www.datadirect.com/developer/...inks/index.ssp (30 day trial can be downloaded)

http://www.easysoft.com (See the ODBC to ODBC Bridge Entry). (A very good
product. I am not sure if there is a free trial download available)

I am starting to write an UNIX ksh shell script to help you accomplish your
goals as described in your earlier post. Thank you.

"frank chang" wrote:

sshaahin,

You could use RSH (remote shell) daemon/service to execute either a batch or
exe file. I've used it to execute commands going from Windows to Unix. I am
sure this can be done in the other direction.

Ilya

"sshaahin" <sshaahin (AT) discussions (DOT) microsoft.com> wrote

Thank you so much for all your help.

Here is the info you asked for last Friday:

1) The UNIX O/S version is HP-UX B.11.00 E 9000/800
2) There is no ODBC on the UNIX box. It uses Sybase Open Client v12.0.

Thanks again.




"frank chang" wrote:

sshaahin, I do not believe the Sybase Open Client v12.0 can provide the
desired connectivity from Unix to Microsoft SQL Server 2000. Have you looked
at Ilya Margolin's suggestion? If that is ok, great. If you want to address
the shell script approach, could you please provide an email (yahoo, hotmail,
aol, etc)? Thank you.

"sshaahin" wrote:

I am looking into Ilya's solution. If I can make that work, that would be
the simplest and most elegant solution. Otherwise, I will have to ask for
your advice. Thanks.

"frank chang" wrote:

sshaahin, Yes, it sounds like the simplest solution. The only concern I have is
whether the rshd daemon process which you will install on the Windows machine
is sufficiently secure to prevent the shell from launching for unintended
users.
Please let us know when you finish your implementation. Thank you.

"sshaahin" wrote: