MSBI Tutor

Sometime we have to read the last row (Footer Row) from flat file. By using Script Task to read a Header Line of flat file. Step 1: Open Microsoft Visual Studio and create a new SSIS project (Ctrl + Shift + N). Step 2: In Control Flow window, Drag and Drop a Script task. Step 3: I have a flat file as shown in bellow. Step 4: Create a two variables as VarFilePath and VarHeader. Variable Name          Data Type                  Value VarFilePath                 String                          C:\Users\challaba\Desktop\Newfolder\ Personal\ Flat Files\Test_File_8192015.txt VarFooter                    String Step 5: Edit Scrip task. Step 6: In bellow window Ready Only Variables as User::VarFilePath Read Write Variables as User::VarFooter Step 7: Click on Edit Script and write a bellow Script. // TODO: Add your code here             String FilFullPath = "" ;             String

Sometime we have to read the first row (Header Row) from flat file. By using Script Task to read a Header Line of flat file. Step 1: Open Microsoft Visual Studio and create a new SSIS project (Ctrl + Shift + N). Step 2: In Control Flow window, Drag and Drop a Script task. Step 3: I have a flat file as shown in bellow. Step 4: Create a two variables as VarFilePath and VarHeader. Variable Name          Data Type                  Value VarFilePath                 String                          C:\Users\challaba\Desktop\Newfolder\ Personal\ Flat Files\Test_File_8192015.txt VarHeader                  String Step 5: Edit Scrip task. Step 6: In bellow window Ready Only Variables as User::VarFilePath Read Write Variables as User::VarHeader Step 7: Click on Edit Script and write a bellow Script. // TODO: Add your code here Using ( StreamReader r = new StreamReader (Dts.Variables [ "Us

Sometime we have to read the first row (Header Row) and last row (Footer Row) from flat file. By using Script Task to read a Header Line of flat file. Step 1: Open Microsoft Visual Studio and create a new SSIS project (Ctrl + Shift + N). Step 2: In Control Flow window, Drag and Drop a Script task. Step 3: I have a flat file as shown in bellow. Step 4: Create a three variables as VarFilePath, VarHeader and VarFooter. Variable Name          Data Type                  Value VarFilePath                 String                          C:\Users\challaba\Desktop\Newfolder\ Personal\ Flat Files\Test_File_8192015.txt VarHeader                  String VarFooter                    String Step 5: Edit Scrip task. Step 6: In bellow window Ready Only Variables as User::VarFilePath Read Write Variables as User::VarHeader and User::VarFooter Step 7: Click on Edit Script and write a bellow Script.

1. SSIS logging Logging is used to log the information during execution of package. A log provider can be a text file, the SQL Server Profiler, a SQL Server relational database, a Windows event log, or an XML file. If necessary, you can define a custom log provider (e.g., a proprietary file format). 2. Error handling Error Handling can be achieved in Data Flow Task by configuring Error Output. --> 3 actions can be performed whenever some error occurs - Ignore Failure - Redirect Row - Fail Component --> By default Fail Component is being used by SSIS --> Ignore Failure - if error occurs, SSIS will ignore that error and move ahead --> Redirect Row - if error occurs, SSIS moves those erroneous (bad) records to different destination and correct records to actual destination. 3. How to use inner join in ssis transformations? By using merge join transformation. 4. Drill down report Drilldown reports initially hide complexity and ena