Create an SSIS package without tab's in the destination flat file..

• shrsan

  SSC Eights!

  Points: 900

  More actions

  April 23, 2013 at 6:08 pm

  #273261

  Hi Everyone,

  Am new to this form am sorry if am rude.

  I have to create an SSIS package by taking data from the flat file which consists of spaces and tab for example: 102 rtrtr yyutut juuy 6565 in which after 102, 3 blank 3 spaces and 1 tab. rtrtr as 4 spaces and 1 tab between rtrtr and yyutut.

  In my destination flat file i must get spaces but not tab.

  Thanks in Advance.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 24, 2013 at 7:02 am

  #1609465

  I can't remember the exact syntax in SSIS but you need to do a replace using the ASCII code for tab which you can find at http://www.asciitable.com/. You can do this with an expression in the derived column transform. There may be another transform you could use as well.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question