Re: SQLDTS Transfer File Task

I should be able to confirm, because I wrote the task, but I'm afraid I cannot as the code is not handy. I'm pretty sure it will only open one connection at run-time, but the design-time will be a lot more free with opening and closing connections.

--
Darren Green
http://www.konesans.com | http://www.sqlis.com | http://wiki.sqlis.com

"Nabeel" <nabeel.moeen@xxxxxxxxx> wrote in message news:1190060858.076811.78350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have an automated task that runs a process to generate files and
then uploads them to an FTP via WS_FTPPro and a script file. the
problem in this scenario is that the WS_FTPPro script transfers
multiple files in individual sessions for each file and the account I
use to sign in on the host has a limited number of logins before it
expires.
E.g. 20 logins. so for 4 files transferred each time the process is
run the logins expire in 5 days.

What I have tried to do, is setup a DTS package that runs the process
to generate files and then use a SQLDTS Transfer File task to transfer
the files to the ftp.
Can anyone confirm whether SQLDTS transfer File task uses a single
session to transfer multiple files?
I would like the account to last as long as possible (its not actually
20, but then again having to have the account reset every x/4 number
of times rather than x number of times is a huge hassle).


Regards,
Nabeel


.

Relevant Pages

  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account will ... Create one or more logins for the applications. ... for each database. ... , you really have no security for your ...
    (microsoft.public.sqlserver.security)
  • Re: Server 2003 Group Policies - Affecting Administrative Profile
    ... If I was you I would remove TS Access rights from the Administrator account ... office" logins as well as remote logins. ...
    (microsoft.public.windows.server.general)
  • Re: Account Login
    ... > account. ... I have found several logins that were preceeded by login ... can get into a computer running any operating system. ...
    (microsoft.public.windowsxp.security_admin)
  • RE: Login Restrictions
    ... I have an application running on a Redhat 9 machine that requires being run ... account that needs to run the application. ... logins and know who su'd to the common account and when they did it. ... message is not the intended recipient or an authorized representative of the ...
    (RedHat)
  • sshd authentication with pam
    ... Then I logged in with a user ID whose account would expire soon and the ... system printed the " account expiration" warning as expected. ... Telnet logins work as expected but we would really like to have ssh ... logins work correctly with password expiration and account lockout. ...
    (SunManagers)