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?

    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

              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