Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: How to read the content of DTS local package?

    I create a local package in DTS a few months ago. And set a schedule to run daily. Now i need to modify. How to read the content of DTS local package? i try to right click the package in job, and edit, but i didn't see the content. How can i see it and modify. Why mine can't be read? Thanks.
    Last edited by yyu; 11-08-04 at 15:24.

  2. #2
    Join Date
    Sep 2004
    Posts
    22
    you need to go under :

    Data Transformation Services ->Local Packages in Enterprise manager.

    You'll see your package there.

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    I can find the package, But i want to see the content. As this is a package that import some of data from another database. So i can't read the content that means the query. I forgot, but i need to modify. Thanks.

  4. #4
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172

    Lightbulb

    YYU I think SQL SERVER 2005 has a utility that allows you to SEE/EDIT your DTS file, regarless of the version used to create this files.

    You can also try to monitor the activty on your SQL SERVER using the PROFILER TOOL, wich comes with SQL SERVER 2000+, and run your DTS files. Your SQL QUERY should appear in your TRACE FILE.

    BTW this forum ROCKS!!

    BIGGGG UP!!

  5. #5
    Join Date
    Mar 2004
    Posts
    660
    Thanks. It is great to have sql server 2005. We will have later. Let's see.

    Thanks again!

Posting Permissions

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