SQL Server Tacklebox- P16: This book, as with almost all books, started out as an idea. I wanted to accumulate together those scripts and tools that I have built over the years so that DBAs could sort through them and perhaps adapt them for their own circumstances. | 3 The migratory data Figure OLE DB Destination Editor properties. Although I did not use it in this example there is also the Rows per batch option that will batch the load process so that any failures can be rolled back to the previous commit rather than rolling back the entire load. It is worth noting that there are other Fast Load options that you cannot see here. In SSIS these options are presented to you only in the Properties window for the destination object. Additional fast load properties include FlRE_Triggers which forces any triggers on the destination table to fire. By default fast or bulk loading bypasses triggers. order which speeds performance when working with tables with clustered indexes so that the data being loaded is pre-sorted to match the physical order of the clustered index. 75 3 The migratory data These properties can be manually keyed into the FastLoadOptions property value. In this example I also used the fire_triggers fast load option as shown in Figure . Figure Additional options for Fast Loading data within SSIS destination objects. It is almost time to execute this simple data migration package. First however I would like to add a data viewer to the process. A data viewer lets you the package designer view the data as it flows through from the source to the destination 76 3 The migratory data object. To add a data viewer simply right-click on the green data flow path and select Data Viewer . This will bring up the Configure Data Viewer screen as shown in Figure . The data viewer can take several forms Grid Histogram Scatter Plot and Column Chart. In this example I chose Grid. Figure Selecting a data viewer. When we execute the package the attached data viewer displays the flow of data. You can detach the data viewer to allow the records to flow through without interaction. The data viewer is useful while developing a package to ensure that the data you are expecting to see is indeed there. Of course you will want to
