Results 1 to 4 of 4

Thread: DTS kick all the way out

  1. #1
    Join Date
    Nov 2002
    Posts
    261

    DTS kick all the way out

    I have a SQL Server 2000 that is used in a web application. It has IIS5 on it and SQL 2000 SP3. I need to make a change to one of the DTS packages. It needs to remap some of the columns in transformations for an export to a text file. Anytime I click on the "create columns for mapping button, it kicks me completely out of SQL Sever. Tried to create a separate package to complete just this step and same thing happens. Reapplied sp3 , still same results. Tried both SQL , sa and winnt admin accounts, still a problem. Anyone seen this before?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There is a problem in SP3 for DTS. Check this out.

    http://support.microsoft.com/default...b;en-us;814113

    You can ask for the fix from them without any charge.

  3. #3
    Join Date
    Nov 2002
    Posts
    261
    thanks for the speedy reply

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Posting Permissions

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