My Database Table is defined as such...

CREATE TABLE [dbo].[FileHeaderRecord](
	[FileHeaderRecordIdentity] [int] IDENTITY(1,1) NOT NULL,
	[RecordType] [char](2) NULL,
	[RecordDescription] [char](12) NULL,
	[LockBoxNumber] [char](6) NULL,
	[BusinessDate] [char](8) NULL,
	[Filler] [char](52) NULL
PRIMARY KEY CLUSTERED 
(
	[FileHeaderRecordIdentity] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

The data looks like so when I SELECT it...

FHTEST        00000108252015                                                    

However, when I set-up my SSIS Package to SELECT from this table and then use "Flat File Destination" it writes the file out...but the format seems wrong...like when I look at it in Notepad++ it appears as so...

FHTEST         000001                                       08252015                                                   

Why the gap between my data columns [LockBoxNumber] and [BusinessDate]???

Thanks for your review and am hopeful for a reply.

You are tab separated and have a few fields between the 00001 and 08.. field?

This is the same question that you asked yesterday:

https://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e2090bc6-1c38-484a-8eb7-3d6757d714b9/#e2090bc6-1c38-484a-8eb7-3d6757d714b9