Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: Advanced topics/features/usage of DTS's

    Hello,

    I know the basics of DTSs and have been using them for a while. Now I REALLY want to learn the advanced concepts related to DTS's e.g.

    1. How to make use of the "Inner Package Global Variables" Tab (which is visible in the DTS Designer "window")
    2. How to make use of the "Outer Package Global Variables" Tab (which is visible in the DTS Designer "window")
    3. How to make use of the "Outer Package Global Variables" Tab (which is visible in the menu bar option #4 Designer "window")


    Many advance thanks for your help.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Joozh
    I know the basics of DTSs and have been using them for a while. Now I REALLY want to learn the advanced concepts related to DTS's
    I can think of much better uses for your time. DTS was a klunky tool to begin with, poorly implemented and poorly integrated into the SQL Server environment. I would never have recommended that anybody use it for anything beyond simple data transfers, and now that it has been completely dropped from the latest SQL Server version 2005 it might be more useful for you to study Latin.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2003
    Posts
    163
    Hmmm... Thanks for the feedback.

    At the moment I don't think my college will be shifting to SQL 2005 and that is why I thought that I'd get better on it. However you have given me some useful food for thought by saying that SQL 2005 doesn't offer DTS's at all.

  4. #4
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Quote Originally Posted by blindman
    I can think of much better uses for your time. DTS was a klunky tool to begin with, poorly implemented and poorly integrated into the SQL Server environment. I would never have recommended that anybody use it for anything beyond simple data transfers, and now that it has been completely dropped from the latest SQL Server version 2005 it might be more useful for you to study Latin.
    Dammit man! Every time I feel smart, you tell me I've been doing it all wrong. Now I'm going to rewrite some huge processes. I hope we don't migrate to 2005 anytime soon.
    Inspiration Through Fermentation

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    SQL Server 2005 dropped the DTS utility, and it has been replaced by something called Integration Services which is an even bigger monstrosity.
    The two utilities have the same concept, but they are sufficiently different that in-depth knowledge of DTS packages is not going to help you with Integration Services.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Will I still be able to execute ActiveX scripts?
    Inspiration Through Fermentation

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Amo, Amas, Amat, Amamus, Amatis, Amant....

  8. #8
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Hey, isn't that basically the Barney song in Latin?
    ("I love you, you love me...")

    What's that have to do with ActiveX and DTS?
    Inspiration Through Fermentation

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    yes, you can executed Active-X script, in more than one way in SSIS. You certainly can do it, and for getting DTS packages running quickly, it is really convenient... When you try to do "heavy lifting" with Active-X in SSIS, you'll be reminded very quickly just how many better choices SSIS offers!

    Push for the conversion to SQL 2005. Push hard!

    -PatP

Posting Permissions

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