Record Length Issue - SQL Server Forums

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

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Record Length Issue

Author

Topic

dsnider
Starting Member

4 Posts

Posted - 2007-08-23 : 14:37:08

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}

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2007-08-28 : 13:33:53

This looks like a simple export. I strongly suggest using the wizard. That is how I have started liking the SSIS.

Regards
Paresh Motiwala
Boston, USA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources