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 Offline
    R Offline
    Rahul_Biswas
    wrote on last edited by
    #1

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

    L Z M 3 Replies Last reply
    0
    • R Rahul_Biswas

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

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

      This has nothing to do with Database, please read How to get an answer to your question - Database Discussion Boards[^].

      Z 1 Reply Last reply
      0
      • L Lost User

        This has nothing to do with Database, please read How to get an answer to your question - Database Discussion Boards[^].

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

        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 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?

          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

                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
                • 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

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

                  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