How to import a fixed width flat file into database using SSIS?
Here is a sample package created using SSIS 2008 R2 that explains how to import a flat file into a database table. Create a fixed-width flat file named Fixed_Width_File.txt with data as shown in the screenshot. The screenshot uses Notepad++ to display the file contents. It has the capability to show the special characters like … Read more