TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
SSIS - How To Create Fixed Width Columns Text File in SSIS
As ETL developer, we get different type of requirements to generate different types of files. In this post we need to create a text file with fixed width columns. We are going to get the data from our SQL table and then create the file.
We will be using the Flat File Destination to create the Fixed Width Columns text output file from SQL server table. Let's Start with Step by Step approach.
Create new SSIS Package. Inside the SSIS Package, Bring the Data Flow Task to the Control Flow Pane.Bring OLE DB Source inside the Data Flow Task. Create the Connection and Choose the table/view from which you want to get the data.
Fig 1: Configure OLE DB Source To Get Data from SQL Table
Fig 2: Choose the Columns From OLE DB Source
Bring the Flat File Destination and connect OLE DB Source to it. Once connected, configure as shown below