Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Problem with SSIS Packages

Author  Topic  dsnider Starting Member 4 Posts Posted - 2007-08-26 : 14:48:52 I am having issues with exporting a file from a table. The data is correct however the Record Length for our mainframe is 100 and the file I am sending is 23036. Any help would be appreciated Mainframe Specifications Record Format: FB Record Length: 100 Block Size: 27900 My SSIS package Export File Record Format: VB Record Length: 23036 Block Size: 27998 Table that is exported (Details) RMSTRANDTE varchar(8) RMSTRANTIM char(4) RMSACCTNUM char(20) RMSTRANCDE char(2) FIELD char(6) HSTNEWVALU char(40) INTEXTCODE char(1) AGENCY char(4) PLATFORM char(4) REGION char(4) PRODUCT char(4) FILLER char(3) ---All Precision Set to Blank ---All Scale set to Blank SSIS Packages Specifications: Flat File Destination Code Page: 1252 Locale: English Format: Fixed Width Row Delimiter: {CR}{LF}