SSIS export of data to a fixed length flat file

• james powers

  SSC Journeyman

  Points: 93

  More actions

  August 30, 2006 at 1:32 pm

  #170227

  Hi Everyone,

  Perhaps you can give me some good advice...I am trying to export data to a fixed length flat file from an openquery from another system and for some reason the data is skewed all through the file...Can anyone help?  Or has anyone run into this problem before...If you see below the data is skewed across the entire file when I open it into ultraedit after creating the file...multiple columns

       281689XXXX11606      281689XXXX11606

    5283XXXX4411809      5283XXXX4411809

  2718XXX1959      2718XXX1959

  541XX43      541XX43

  492      492

   

   

  select * from openquery(td,'

  SELECT

   cast(c.NAME as char(40)),

   cast(c.AREN as char(9)),

   cast(b.AID as char(20)),

   cast(c.AADR as char(40)),

   cast(c.AUNT as char(40)),

   cast(c.AENCY as char(30)),

   cast(c.ARET as char(2)),

   cast(c.ARNZ5 as char(5))

  FROM Table1 a

  JOIN Table2 b on a.ARID = b.AACID

  JOIN Table 3 c ON a.ARD = c.AROD

  WHERE a.TYPID = ''PRIM''

    AND a.ASTATUSID = "DONE"

  ')

       

  492

• September 4, 2006 at 8:00 am

  This was removed by the editor as SPAM

• k man

  SSC-Addicted

  Points: 432

  More actions

  May 7, 2007 at 8:05 am

  #704643

  Seeing the Same issue...have been trying to figure out for a little while now...If somebody knows of a solution please respond.