We can currently use a DTS to copy data from a SCO Unix .ddf file (as text) to a SQL Server 2000 table. This works if we run the DTS manually, but when we schedule it, we get an error “invalid password”. How do we set up connection (with userid andpassword) so we can automate this job?
