Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    56

    Question Unanswered: Data Transformation Services, Legacy

    On SQL2005, I have some legacy packages that were imported from SQL2000. I am able to open & execute the package using DTS 2000 Package Designer. The package executes successfully but when I query the table that the package is supposed to load, the contents of the table were not changed.

    What security is supposed to be set inorder for the package to function correctly?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You've confused me...
    Does the DTS work correctly, as you expect, when you run it via the designer?
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2007
    Posts
    56
    Quote Originally Posted by georgev
    You've confused me...
    Does the DTS work correctly, as you expect, when you run it via the designer?
    I receive a "Package Execution Results" window that tells me "Successfully completed execution of package."

    The "Executing DTS Package: DASD" window shows a status of complete for each step. Step 3 shows that 15973 were loaded to a table, however, when I query the table, there are 16500 records.

    I don't understand why the table is not being updated.

Posting Permissions

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