Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: SSIS - Why, Dear Lord, Why

    So DTS is as dead as a door nail, now it's SSIS....


    So I ask you people, why are you still using these GUI pieces of garbage?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Having never used SSIS (SQL Server Information Services?) I have no idea what it even is! I have (and do) use DTS packages occoasionally, I see no harm...
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by georgev
    I have (and do) use DTS packages occoasionally, I see no harm...
    A guy over at SQLTeam has, as part of his sig, "DTS is useful if you don't know SQL".
    I don't know of anything you can do in DTS that you can't do in SQL - it may be ignorance of course. However, I do know it is a bugger to debug, poor error handling, tricky to move\ run (compared to code), another gui to learn etc.. EDIT - locks you into something that may go unsupported in the future. This defo applies to SSIS too, no matter how improved it is.

    So yeah - I don't use DTS at all. I think most of regs here only use it for adhoc stuff. I have sprocs that I have written that I use for adhocs so I don't even use it for that.

    Not looked at SSIS yet. Not really planning to either.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    Quote Originally Posted by georgev
    SQL Server Information Services?
    close. it's Integration services.

    and no, I don't use either one.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm trying to play with it now...but I can't find it...yet
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Wow..a simple export of 1 table to excel, and look what it does! Holy sheet

    EDIT: Well that didn't come out to well, but basically it has like 15 steps

    EDIT2: If you 2x click on it you can increase he picture size
    Attached Thumbnails Attached Thumbnails SSIS.JPG  
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by Poots
    A guy over at SQLTeam has, as part of his sig, "DTS is useful if you don't know SQL".
    But I do know SQL!

    And That screenie made me laugh Brett :
    1. ...
    2. Prepare for Execute
    3. Pre-execute
    4. Executing
    5. Copying data
    6. Post-execute
    George
    Home | Blog

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I use DTS and SSIS because it is an MS Standard, and as a consultant I have to use technologies and standards that customers may already have in place, and that they will support in the future.
    If I was writing processes that would only be supported by me, or within my own company, I might not use DTS.
    Frankly, I found DTS very useful for simple data transfers. I have not issues with it for that. The problems come when trying to shove too much business logic into it. So my processes typically only use DTS to transfer data to staging tables and then kick off a sproc to cleanse and verify the data and load it into production.
    If it's not practically useful, then it's practically useless.

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

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How do you migrate a DTS package in DEV to production if you have to hand all code over to prod dba's and you're not incolved in the prod environment?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Its a three step process:
    1) Hello, Prod DBA.
    2) Here is the development package. Change all the references to production.
    3) Gee, thanks! You guys are swell. See you tomorrow.
    If it's not practically useful, then it's practically useless.

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

  11. #11
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Copying table CreditCard? You don't work for TJX, do you, Brett? ;-)

    Actually, I should give credit where it is due. DTS in SQL 2000 introduced a .ini file reader. I accept no package without one. If their new package sends all their data to the test system, well, that is hardly my concern. The package works exactly as they (cheaply and without thought) wrote it.

  12. #12
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by Brett Kaiser
    How do you migrate a DTS package in DEV to production if you have to hand all code over to prod dba's and you're not incolved in the prod environment?
    We use a separate namespace in DNS for our applications with an identical namespace in production. When we migrate applications and scripts from test to prod, the names don't change.

    Alternatively, you would make more extensive use of external configuration files and the SSIS equivalent of the DTS dynamic properties task to set server connection strings at runtime.

    As for the original question...I'm not a huge fan of SSIS (yet), but DTS was a huge "force multiplier" for me in the past. It made me much more productive by allowing me to work directly with remote data sources (which I usually did not manage and to which I was only granted limited access). I tried doing some of the same tasks with linked servers and T-SQL, but I usually found DTS to be much faster.

    Is DTS/SSIS evil? No. Is it good? No.

    In the end, it's another tool. You can learn it and use it or ignore it and find other ways to do your work. As blindman said, it's something that MS wants to push and will likely be around for some time to come (in one form or another).

    As for SSIS, there are lots of things that I don't yet like about it. Among the biggest things I dislike is the process for deploying it into a clustered environment. I said before on an earlier post that M$ has taken an elegantly simple tool and made it much more complex. This detracts from the value that I can add to my job until I can take the time to really learn how to use it.

    Regards,

    hmscott
    Have you hugged your backup today?

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Good points all...Ii guess I will learn it like I did DTS just becasue a lot of developers will use it, and then scream bloody murder when "it doesn't work", so I get to ride in and fix it....BUT I hate it when they code ActiveX stuff

    I still can't find where it resides however
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Nowadays you need to install a SSIS Server to execute the packages. You create them in the Business Integration Development Studio. I looked for them in SQL Workbench for a while myself.

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You've GOT to be kidding me

    Where is BIDS?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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