General discussion

Locked

DTS from SCO UNIX to SQL Server 2000

By davet ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

DTS from SCO UNIX to SQL Server 2000

by Glen_McLeod In reply to DTS from SCO UNIX to SQL ...

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

Collapse -

DTS from SCO UNIX to SQL Server 2000

by davet In reply to DTS from SCO UNIX to SQL ...

Poster rated this answer

Collapse -

DTS from SCO UNIX to SQL Server 2000

by davet In reply to DTS from SCO UNIX to SQL ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums