Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Most complex SSIS package you have worked on

Most complex SSIS package you have worked on

Scheduled Pinned Locked Moved Database
questionsql-server
13 Posts 4 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Rahul_Biswas

    What is the most complex SSIS package you have worked on? What did you learn from its implementation?

    Z Offline
    Z Offline
    ZurdoDev
    wrote on last edited by
    #4

    Not sure why you were downvoted but I think this is a great discussion topic. I upvoted to help counter it. I used SSIS very little, thank goodness. :-D

    There are only 10 types of people in the world, those who understand binary and those who don't.

    1 Reply Last reply
    0
    • Z ZurdoDev

      Actually SSIS is very much databases. It is a tool to transfer data from one data source to another.

      There are only 10 types of people in the world, those who understand binary and those who don't.

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #5

      So we are now allowed to discuss resharper in the C# forum? It is a tool for C# after all :)

      Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

      Z 1 Reply Last reply
      0
      • L Lost User

        So we are now allowed to discuss resharper in the C# forum? It is a tool for C# after all :)

        Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

        Z Offline
        Z Offline
        ZurdoDev
        wrote on last edited by
        #6

        Where would you suggest posting a discussion on SSIS? Is there a forum that you think is more appropriate than this one?

        There are only 10 types of people in the world, those who understand binary and those who don't.

        L 2 Replies Last reply
        0
        • Z ZurdoDev

          Where would you suggest posting a discussion on SSIS? Is there a forum that you think is more appropriate than this one?

          There are only 10 types of people in the world, those who understand binary and those who don't.

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #7

          It's really a Lounge discussion subject, it's not a technical question.

          Z 1 Reply Last reply
          0
          • Z ZurdoDev

            Where would you suggest posting a discussion on SSIS? Is there a forum that you think is more appropriate than this one?

            There are only 10 types of people in the world, those who understand binary and those who don't.

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #8

            RyanDev wrote:

            Where would you suggest posting a discussion on SSIS?

            The Lounge.

            RyanDev wrote:

            Is there a forum that you think is more appropriate than this one?

            Nope. Are you suggesting we need a new forum for SSIS or tools? Just wondering how this would reflect on the C# forum, and no, I don't have a decent answer.

            Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

            Z 1 Reply Last reply
            0
            • L Lost User

              It's really a Lounge discussion subject, it's not a technical question.

              Z Offline
              Z Offline
              ZurdoDev
              wrote on last edited by
              #9

              Richard MacCutchan wrote:

              Lounge discussion subject,

              Could be, but I would bet if OP put it in the Lounge they'd get flamed by many.

              Richard MacCutchan wrote:

              it's not a technical question.

              It's a good topic for discussions, which is what these forums are, discussions. However, I now notice that at the top of the discussions forum it says "how to ask a question." Personally, I see QA as quick questions with direct answers and these discussion forums for discussions. I found it very appropriate.

              There are only 10 types of people in the world, those who understand binary and those who don't.

              L 1 Reply Last reply
              0
              • L Lost User

                RyanDev wrote:

                Where would you suggest posting a discussion on SSIS?

                The Lounge.

                RyanDev wrote:

                Is there a forum that you think is more appropriate than this one?

                Nope. Are you suggesting we need a new forum for SSIS or tools? Just wondering how this would reflect on the C# forum, and no, I don't have a decent answer.

                Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

                Z Offline
                Z Offline
                ZurdoDev
                wrote on last edited by
                #10

                Eddy Vluggen wrote:

                need a new forum for Tools?

                No, we already have Facebook, er, I mean the Lounge. :-\

                There are only 10 types of people in the world, those who understand binary and those who don't.

                L 1 Reply Last reply
                0
                • Z ZurdoDev

                  Eddy Vluggen wrote:

                  need a new forum for Tools?

                  No, we already have Facebook, er, I mean the Lounge. :-\

                  There are only 10 types of people in the world, those who understand binary and those who don't.

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #11

                  "The Lounge" was answered in jest, but it should be allowed there; it's not a programming question. The C# forum would become a very broad subject if we discussed/accepted each utility available.

                  Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

                  1 Reply Last reply
                  0
                  • Z ZurdoDev

                    Richard MacCutchan wrote:

                    Lounge discussion subject,

                    Could be, but I would bet if OP put it in the Lounge they'd get flamed by many.

                    Richard MacCutchan wrote:

                    it's not a technical question.

                    It's a good topic for discussions, which is what these forums are, discussions. However, I now notice that at the top of the discussions forum it says "how to ask a question." Personally, I see QA as quick questions with direct answers and these discussion forums for discussions. I found it very appropriate.

                    There are only 10 types of people in the world, those who understand binary and those who don't.

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #12

                    RyanDev wrote:

                    if OP put it in the Lounge they'd get flamed by many.

                    I don't see why, as it is not a programming question, more a general request for opinions and experiences. Plenty of similar discussions appear in the Lounge. I know these forums are titled "Discussions", but in reality they are for asking Technical Questions.

                    1 Reply Last reply
                    0
                    • R Rahul_Biswas

                      What is the most complex SSIS package you have worked on? What did you learn from its implementation?

                      M Offline
                      M Offline
                      Mycroft Holmes
                      wrote on last edited by
                      #13

                      Ignore Richard and the bastard, this is an appropriate question in the correct forum. Unfortunately your question is a little too broad to elicit a reasonable response. SSIS is such a wide subject. I do know that we moved from ETL to ELT where the transforms are done via stored procedure. It is faster and I find it easier to debug and test. So SSIS just moves the data from the source into staging tables and launches the transform stored proc.

                      Never underestimate the power of human stupidity RAH

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups