At my disposal I only have a SQL Server 2000 without (no) access to xprocs. It is VBScript, PerlScript and TSQL that I've got. I do not know Perl.
I am looking for advice on how to secure the Username and Password used in a FTPTask.
I have qute a few tasks like this and the password is going to change after deployment, so my DTS configures itself from a table, which is where the PWD would be stored too...
Any ActiveXScript encryption, even simple stuff will do, so long as the pwd cannot be obviously read.
Please help. Thank you in advance.