dbTalk Databases Forums  

Export to a fixed length "flat-file" using SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Export to a fixed length "flat-file" using SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dabuld@hotmail.com
 
Posts: n/a

Default Export to a fixed length "flat-file" using SSIS - 10-25-2006 , 03:49 PM






I have to export to a fixed length file which has the following
structure

A1234 RT XXX XXX
BXXXXXXXXXXXXXXRT JJ
C JJJ IUD
A1234 RT XXX YYY
BXXXXXXXXXXXXXXUU OO
C JJJ ABC
....
....

If you look at the structure you can see that each row ( the first 3 )
have a different layout. This pattern repeats after the 3rd row. I was
wondering if I could use SSIS to create this file.

Thanks,
Pete


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.