Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create an SSIS package without tab's in the destination flat file.. Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 6:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 8:31 PM
Points: 18, Visits: 117
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.
Post #1445734
Posted Wednesday, April 24, 2013 7:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 10,215, Visits: 13,163
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1445930
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse