DTS question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS question

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-28 : 08:01:37

Phil writes "Hi,

A little background on our issue... We have a job that executes a DTS package. The job lives on some local clients. The local clients have MSDE installed on them and have the same database as our server. The job runs daily and copies users, stored procedures, and tables from the server down to these clients. The issue comes into play whenever we add a new user to the server. The job will fail because DTS doesn't recognize that user on the clients. Is there any way to create perhaps another job or some other method so that whenever we create a new user this job won't fail? Right now we have to manually update that job each time we have a new user. A lot of times we forget to do it and this causes problems. Any input whatsoever would be appreciated.

Thanks,
Phil"

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-10-28 : 08:29:29

if it copies down users... what is it failing on...

can you explain a little further...