Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    35

    Unanswered: DTS Unspecified error

    I have a DTS to transfer logins from one server to a another server. I have put the syslogins.dat file in the share directory. But this DTS is giving 'Unspecified Error'. Any help would be appreciated.

    Thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    7
    I would not try copying a dat file. Use tranfer SQL Objects.

  3. #3
    Join Date
    Jan 2004
    Posts
    35
    I guess, the dat file has nothing to do with this DTS. Because, the transfer logins task takes just the source and destination servers. I'm not sure how it transfers the logins and why it should give 'Unspecified error'.

  4. #4
    Join Date
    Jan 2004
    Posts
    7
    Are you saying you are not copying the dat? And the DTS is trying to transfer the logins?

    What about permissions on both servers?

  5. #5
    Join Date
    Jan 2004
    Posts
    35
    I'm not copying the dat file.
    What permissions should I check. I ran this DTS from Enterprise Manager. The logins are same in source and destination server.

    I just tried to run it through a job and it failed with error 2147467259 (80004005).

  6. #6
    Join Date
    Jan 2004
    Posts
    35

    Angry

    I just tried SQL Server Authentication instead of Windows Authentication and it still gives the same problem. I don't know what the heck this 'Unspecified error' means and this is driving me crazy

  7. #7
    Join Date
    Jan 2004
    Posts
    7
    If you have not tried this...
    Change the task to something that should have no trouble completeing.
    In other words does any work with that DTS?

  8. #8
    Join Date
    Jan 2004
    Posts
    35
    Yes. All the other DTS packages execute properly. I just tried 'create table','delete table', 'connection to excel'..etc. and everything just completed fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •