Re: DTS Error - Step 1

From: Dave Karmens (spam_just1coder_at_yahoo.ca)
Date: 03/11/04


Date: Thu, 11 Mar 2004 11:21:35 -0500
To: "Farooq Mahmud [MS]" <farooqm@online.microsoft.com>

The SQLAdmin account doesn't need FTP access. The packages uses the FTP
control in DTS.

d:\tmp has EVERYONE + FULL.

When I use DTSRUN to execute the package it works fine, but on a
schedule it doesn't.

Farooq Mahmud [MS] wrote:
> Does CDB1\SQLAdmin have appropriate permissions to the FTP site where the
> images are held and to D:\tmp ?
>
> Regards,
> Farooq Mahmud [MS SQL Support]
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
>



Relevant Pages

  • Re: error in scheduled job
    ... Dan ... > fail on the first step which is to download a file from the ftp ... > When I try to use an Execute Process Task to run a batch file, ... The packages are owned by the administrator. ...
    (microsoft.public.sqlserver.dts)
  • Re: Building 2.6.10 kernel for Debian and ncurses
    ... >> packages which are already installed and work fine. ... >sourceforge.net for available chroot tools for SSH. ... account not unlike the concept of anonymous login for ftp. ... although the end users have to enter user IDs and passwords ...
    (comp.os.linux.setup)
  • [OpenPKG-SA-2002.012] OpenPKG Security Advisory (samba)
    ... Vulnerability: code execution, root exploit ... Affected Releases: Affected Packages: Corrected Packages: ... discovered by the Debian Samba maintainers. ... fetch it from the OpenPKG FTP service or a mirror location. ...
    (Bugtraq)
  • [OpenPKG-SA-2002.015] OpenPKG Security Advisory (tetex)
    ... Vulnerability: remote command execution ... Affected Releases: Affected Packages: Corrected Packages: ... attacker to execute arbitrary commands via cleverly crafted DVI files. ... fetch it from the OpenPKG FTP service or a mirror location. ...
    (Bugtraq)
  • Re: many packages not available
    ... Using this is mentioned in the handbook to get "the latest version of your ... that pointyhat has a more recent version. ... It will have hard time finding packages corresponding to the present state ... of you port tree on the ftp server, while it will find them easier on ...
    (comp.unix.bsd.freebsd.misc)