Hi,

Here is the screenshot of the job and the first 10 rows of the source data.

Thanks,
Aditya

JE Line Creation Date,JE Batch Name,Entity,Account,Dept,SubDept,Batch Status,Je Line Num,Entered Dr,Entered Cr,JE Line Description,Vend Nm/Inv Batch No/Line Type Ref 1,Invoice_Id - Ref 2,Invoice Dist No/PO/Req Hdr ID - Ref 3,PO Num/Req Num/Check Num - Ref 4,Invoice Num/Req Hdr Desc - Ref 5,Je Category Name,Je Source Name,User Name,Batch Default Period Name,JE Header Posted Date,Je Header Je Source,Gl Header Description,Actual Flag,Header Period Name,Net Change,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,Attribute9,No1,Reference 6,Reference 7,Reference 8,Reference 9,Reference 10,Line Type Code,Full Name
10/2/2007 16:41,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788202: A 2588265,15,10100,0,0,P,2,1234,0,Lockbox Acct#747480044 9/24/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788202:,A,9/7/2008,1234,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:41,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788202: A 2588265,15,10100,0,0,P,1,4321,0,Lockbox Acct#747480044 9/7/07 to 9/21/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788202:,A,9/7/2008,4321,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/9/2007 10:32,MCW-093007-Reclass Cash Balance Spreadsheet 10863912: A 2604782,15,10100,0,0,P,1,0,2345678,Reclass Cash Balance,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/9/2007 12:30,Spreadsheet,Journal Import 10863912:,A,9/7/2008,2345678,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/4/2007 14:15,MCW-093007-To relieve AmEx and Discover R Spreadsheet 10817592: A 2596659,15,10200,0,0,P,3,5678,0,Account -0051 from 9/20/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/4/2007 16:30,Spreadsheet,Journal Import 10817592:,A,9/7/2008,5678,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/4/2007 14:15,MCW-093007-To relieve AmEx and Discover R Spreadsheet 10817592: A 2596659,15,10200,0,0,P,1,3456,0,Account -0085 from 9/21/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/4/2007 16:30,Spreadsheet,Journal Import 10817592:,A,9/7/2008,3456,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:41,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788202: A 2588265,15,10200,0,0,P,3,0,1234567,Cash Receipts from 9/24/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788202:,A,9/7/2008,1234567,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:43,MCW-093007-JE #1 Lockbox Cash Receipts Spreadsheet 10788231: A 2588283,15,10200,0,0,P,1,1234567,0,Cash Receipts from 9/24/07 to 9/28/07 Orig. post to wrong acct.,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788231:,A,9/7/2008,1234567,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:45,MCW-093007-JE #2 C Card Acct Recv Spreadsheet 10788251: A 2588295,15,10200,0,0,P,1,1234567,0,Cash received from 9/24/07 to 9/28/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788251:,A,9/7/2008,1234567,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/2/2007 16:45,MCW-093007-JE #2 C Card Acct Recv Spreadsheet 10788251: A 2588295,15,10200,0,0,P,2,3456789,0,Cash received from 9/4/07 to 9/21/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/2/2007 16:58,Spreadsheet,Journal Import 10788251:,A,9/7/2008,3456789,,,,,,,,,,,,,,,,,"Wolf, Michelle"
10/9/2007 13:06,MCW-093007-JE #3 C Card Disbursement Spreadsheet 10866403: A 2605291,15,10200,0,0,P,1,0,654321,Exhb Payments WE 09/23/07,,,,,,Reclass,Spreadsheet,MWOLF3647,9/7/2008,10/9/2007 13:12,Spreadsheet,Journal Import 10866403:,A,9/7/2008,654321,,,,,,,,,,,,,,,,,"Wolf, Michelle"

Hi,

I am using TOS 2.3.2 to load a CSV file into a SQL Server 2005 table. The problem I am having is with the string columns. All the string columns are appended with white spaces to the number of characters defined in the table. If I write the same data to a text file or an excel file it seems fine. I just can't get this to work.

I am using a Java project and I am using tMSSqlOutputBulkExec (other options also give the same error) to write the data. Please let me know what I am doing wrong.

Regards,
Aditya