{"id":7283,"date":"2019-06-25T11:57:47","date_gmt":"2019-06-25T11:57:47","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7283"},"modified":"2019-09-11T12:12:05","modified_gmt":"2019-09-11T12:12:05","slug":"ssis-trash-destination-dummy-data-source-example","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-trash-destination-dummy-data-source-example\/","title":{"rendered":"Using SSIS Trash Destination and Dummy Data Source"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"In this article, you will learn Using SSIS Trash Destination and Dummy Data Source (FREE). You can write data into the file using Trash Destination, You can use Trash Destination to write data into a raw file from any source. We will use FREE Dummy Data Source to generate random data for testing purpose. Trash Destination can be used to terminate your dataflow pipeline without doing any expensive processing on incoming data. This component is very useful during testing where you want to focus on the source and transforms but don’t really care about the destination.<\/p>\n

 <\/p>\n

Prerequisites<\/span><\/h2>\n

Before we perform the steps listed in this article, you will need to make sure the following prerequisites are met:<\/p>\n

    \n
  1. SSIS<\/abbr>\u00a0designer installed.\u00a0Sometimes it is referred to as\u00a0BIDS<\/abbr>\u00a0or\u00a0SSDT<\/abbr>\u00a0(download it from Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a>\u00a0is installed (download it<\/a>).<\/li>\n<\/ol>\n

    Components mention in this article<\/h2>\n
    \n\n\n\n\n
    \"\"<\/a><\/td>\nZS Trash Destination<\/a><\/td>\n<\/tr>\n
    \"\"<\/a><\/td>\nZS Dummy Data Source<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    Getting Started<\/h2>\n

    SSIS ZS Trash Destination and Dummy Data Source are free. If you check save Data to file then by default all input columns are logged to file. If you wish to log the selected input column then use Advanced Editor. This component does not support an error output. Any bad random value ill cause error or Truncation (e.g. If your sample value is 5 characters long but output column length is set to 3 chars). If you have error output attached with RedirectRow option on error, Truncation then you can capture bad rows along with an exact reason of error.<\/p>\n

    Write data into the file using Trash Destination<\/h2>\n

    Overview<\/h3>\n

    In this tutorial, you will learn how to\u00a0Using SSIS Trash Destination and Dummy Data Source.\u00a0 Let’s use ZS DummyData Source to write data into ZS Trash Destination. Here you can select our, any of suitable Source Adapter<\/a>.<\/p>\n

    Method 1 \u2013 Using ZS DummyData Source<\/span><\/h3>\n
      \n
    1. Open Visual Studio and Create New SSIS Package Project.<\/li>\n
    2. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.\n
    3. Double click on the Data Flow task to see the Data Flow designer surface.<\/li>\n
    4. From the SSIS toolbox drag and drop ZS DummyData Source on the data flow designer surface.\n
      \"Drag<\/a>

      Drag and Drop ZS DummyData Source<\/p><\/div><\/li>\n

    5. Double click DummyData Source and select Customer profile from Template dropdown.<\/li>\n
    6. Once you change Template you will notice that a lot of columns automatically added. Notice how sample values are set for many columns along with their value delimiter. You may use many inbuilt placeholders in your sample values such as ({NULL} for a null value, {TAB} for the tab character, {CRLF} for new line).<\/li>\n
    7. Change [How many rows] setting to 5000.\n
      \"SSIS<\/a>

      SSIS DummyData Source – Configure<\/p><\/div><\/li>\n

    8. Click OK to save settings.<\/li>\n
    9. We can use DummyData Source like this, click\u00a0here.<\/a><\/li>\n
    10. Here, you can insert data into SQL Server Table, Check\u00a0Here.<\/a><\/li>\n
    11. Now, Just Drag and Drop Our Free ZS Trash Destination on the data flow designer surface from SSIS Toolbox.\n
      \"SSIS<\/a>

      SSIS Trash Destination – Drag and Drop<\/p><\/div><\/li>\n

    12. Now single click on ZS DummyData Source once you see the blue arrow from the source … connect it to ZS Trash Destination.<\/li>\n
    13. Double click on ZS Trash Destination to configure it.\n
      \"SSIS<\/a>

      SSIS Trash Destination – Configure<\/p><\/div><\/li>\n

    14. Click OK to save configure setting UI.<\/li>\n
    15. Right-click on the path and Add Data Viewer.<\/li>\n
    16. Execute the package and verify source data in the data viewer.\n
      \"Execute<\/a>

      Execute Package and Verify Data Source<\/p><\/div><\/li>\n<\/ol>\n

      Method 2 \u2013 Using OLE DB Source<\/span><\/h3>\n

      Let’s use ZS OLE DB Source to write data into ZS Trash Destination.<\/p>\n

        \n
      1. Open Visual Studio and Create New SSIS Package Project.<\/li>\n
      2. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.\n
      3. We are going through SQL Server Database, need OLE DB Connection for Data Source.<\/li>\n<\/ol>\n

        How to create OLE DB Connection.<\/h4>\n
          \n
        1. Let’s, Right-click on Connection Managers Panel to Create OLEDB Connection, so you can use Source and Context Menu will appear, Select New OLEDB Connection from the Context Menu.\n
          \"Create<\/a>

          Create OLE DB Connection<\/p><\/div><\/li>\n

        2. Now, click on New button for create Connection.\n
          \"Create<\/a>

          Create New OLE DB Connection<\/p><\/div><\/li>\n

        3. In the Connection Manager, just follow the steps in the following image we have created.\n
          \"OLE<\/a>

          OLE DB Connection Configure<\/p><\/div><\/li>\n

        4. Click on OK button to save connection configure setting UI.<\/li>\n<\/ol>\n

          How to write into Trash Destination from OLE DB Source<\/h4>\n
            \n
          1. Drag and Drop OLE DB Source from SSIS toolbox.\n
          2. Double click on OLE DB Source for configure it.<\/li>\n
          3. In the Connection Manager, just follow the steps in the following image we have created.\n
            \"OLE<\/a>

            OLE DB Source – Configure<\/p><\/div><\/li>\n

          4. Click on OK button to save OLE DB Source Editor setting UI.<\/li>\n
          5. Now, Just Drag and Drop Our Free ZS Trash Destination on the data flow designer surface from SSIS Toolbox.\n
            \"SSIS<\/a>

            SSIS ZS Trash Destination – Drag and Drop<\/p><\/div><\/li>\n

          6. Now, single click on OLE DB Source once you see the blue arrow from the source … connect it to ZS Trash Destination.<\/li>\n
          7. Double click on ZS Trash Destination to configure it.\n
            \"SSIS<\/a>

            SSIS ZS Trash Destination – Configure<\/p><\/div><\/li>\n

          8. Click OK to save configure setting UI.<\/li>\n
          9. Right-click on the path and Add data viewer.<\/li>\n
          10. Execute the package and verify source data in the data viewer.\n
            \"Execute<\/a>

            Execute Package and Verify Data<\/p><\/div><\/li>\n<\/ol>\n

            Conclusion<\/h2>\n

            In this blog, we learned how to write data into a raw file and read data in SSIS. We used the Trash Destination for write data and Dummy Data Source to read data. You can download SSIS PowerPack from here<\/a>\u00a0to try many other scenarios not discussed in this blog. SSIS PowerPack is a collection of 70+ high performance, just drag and drop connector\/task for SSIS(i.e. Microsoft SQL Server Integration Service). After you install SSIS PowerPack you will see many new Custom Tasks and Components in your Visual Studio SSIS Toolbox.<\/p>\n

            References<\/h2>\n

            Finally, you can use the following links for more information:<\/p>\n