3/15/2021 0 Comments Ssis Package Example
The package given below reads the data from a source tab delimited text file and based on certain conditions, saves the output in two separate Excel Output Files.The output Excel files also have the same header as the input text file.
The structure and data for the source input file is given below. If first row of source file contains headers, then select the checkbox Column names in the first data row. It will show Data flow Container tab for selected Data Flow Task. Data flow transformations - Transformations can perform tasks such as updating, summarizing, cleaning, merging, and distributing data. Data flow destinations - Destination writes the data from a data flow to a specific data store, or creates an in-memory dataset. If source file contains null values, select Retain null values from Source as null values in the data flow checkbox. Redirect Row: Selecting this will redirect the failed rows to other component which is connected with the error precedence constraints. Fail component: Selecting this will stop the execution of package in case of failure. Drag and Connect the success output (which is shown by Green arrow) of Flat File Source Component to Conditional Split Component. ![]() Connect the success arrow of the Conditional Split Component to Excel Destination, Input Output selection window will be popped up. Using this component, convert input data types to required output data types. Double click on Excel Data Conversion Component and click on the mapping tab and map the output of Data Conversion Component to input of Excel Destination Component and click ok. Add one more Excel Destination Component and rename it as Remaining Records. Create a new connection manager and configure it to point to the second Output File. Connect the input of the newly added Data Conversion Component to it and do the mapping as required. Go to the Solution Explorer and right click on the package and select Execute Package. If all components turn GREEN, it means package has run successfully, if there is any error, the component which has failed to execute will be shown in RED Color.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |