Discussion Locked

DTS from SCO UNIX to SQL Server 2000

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by glen_mcleod

If it works when you're logged on, and you haven't given the connection object a user and password, then it's using the credentials of the currently logged on user (you) to connect to the SCO system when you're running it interactively. You probably have the appropriate permissions.

You have to specify a user and password with applicable rights on the SCO system in the DTS connection object.

Glen

This discussion is closed to new replies.