Professional Web Applications Themes

DTS Error - Microsoft SQL / MS SQL Server

We have a client with 2 connected SQL servers, development & production. I am having a problem using DTS to move objects between the 2. If I use the option to DTS tables and data, it all works fine - so connection is not the issue. However if I try to use the option to DTS objects, such as stored procedures, I get the message 'An error occurred' (real helpful) and the transfer fails. I dont know where to start on this. I guess I could recommend they reinstall SQL on both servers but there is perhaps a less dramatic ...

  1. #1

    Default DTS Error

    We have a client with 2 connected SQL servers, development & production. I
    am having a problem using DTS to move objects between the 2. If I use the
    option to DTS tables and data, it all works fine - so connection is not the
    issue. However if I try to use the option to DTS objects, such as stored
    procedures, I get the message 'An error occurred' (real helpful) and the
    transfer fails.

    I dont know where to start on this. I guess I could recommend they
    reinstall SQL on both servers but there is perhaps a less dramatic fix?

    Any suggestions or advice from others with experience of this issue
    gratefully received


    Andrew C Guest

  2. #2

    Default DTS Error

    Suggestion: Check if the permission on the store
    procedures is the same as in both servers before doing DTS.

    Another suggestion is to post your question again in
    the 'sqlserver.dts' area where you might get more answers.

    Good luck!
    >-----Original Message-----
    >We have a client with 2 connected SQL servers,
    development & production. I
    >am having a problem using DTS to move objects between the
    2. If I use the
    >option to DTS tables and data, it all works fine - so
    connection is not the
    >issue. However if I try to use the option to DTS
    objects, such as stored
    >procedures, I get the message 'An error occurred' (real
    helpful) and the
    >transfer fails.
    >
    >I dont know where to start on this. I guess I could
    recommend they
    >reinstall SQL on both servers but there is perhaps a less
    dramatic fix?
    >
    >Any suggestions or advice from others with experience of
    this issue
    >gratefully received
    >
    >
    >.
    >
    Jane Guest

  3. #3

    Default DTS Error

    Are both sql versions the same?
    >-----Original Message-----
    >Suggestion: Check if the permission on the store
    >procedures is the same as in both servers before doing
    DTS.
    >
    >Another suggestion is to post your question again in
    >the 'sqlserver.dts' area where you might get more
    answers.
    >
    >Good luck!
    >>-----Original Message-----
    >>We have a client with 2 connected SQL servers,
    >development & production. I
    >>am having a problem using DTS to move objects between
    the
    >2. If I use the
    >>option to DTS tables and data, it all works fine - so
    >connection is not the
    >>issue. However if I try to use the option to DTS
    >objects, such as stored
    >>procedures, I get the message 'An error occurred'
    (real
    >helpful) and the
    >>transfer fails.
    >>
    >>I dont know where to start on this. I guess I could
    >recommend they
    >>reinstall SQL on both servers but there is perhaps a
    less
    >dramatic fix?
    >>
    >>Any suggestions or advice from others with experience
    of
    >this issue
    >>gratefully received
    >>
    >>
    >>.
    >>
    >.
    >
    Jaime E. Maccou Guest

Similar Threads

  1. Replies: 0
    Last Post: March 29th, 09:49 PM
  2. Replies: 0
    Last Post: November 10th, 05:24 PM
  3. Postscript Print error (ERROR: rangecheck; OFFENDING COMMAND: filter)
    By Darrell_J_Brown@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: May 13th, 11:24 AM
  4. Replies: 0
    Last Post: September 25th, 03:23 AM
  5. Replies: 1
    Last Post: August 7th, 07:13 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139