Export table to variable length text file.

• David Lester

  Hall of Fame

  Points: 3647

  More actions

  July 28, 2008 at 3:14 pm

  #123381

  I have a requirement for an outbound EDI exchange which has me stumped. I need to take a table and output it to a text file, which has no row delimiter, and each row should only be as long as the actual data. i.e. if the field is varchar(100) but the specific data item is 50 long, I need the record to be only 50 long in the text file, while the next record might be 75 long, so 75 in the text file.

  I am using a DTS package to process and create the data, and I would think I could create the text file via an activex task, I am wondering if there is a different way to do so.

  Any thoughts?

  Thanks!

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 28, 2008 at 4:56 pm

  #849515

  Just a thought to kindle your creativity. In your code

  Right trim the VARCHAR data returned

  append a CHAR(10) -for a line feed

  and a CHAR(13) - for a carriage return

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]