how can i export sql data with tab space in the columns by using SSIS

Posted on 2014-08-13
Last Modified: 2016-02-11
 i try to export some data to a text file by using SSIS, the problem is there is a Text column  with a tab space, and when i try to export that Text column, the tab cause the problems.

the table column [note]
[note] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[note] text_stream[DT_text]
and the column delimiter is Tab{t}

is any way to avoid this, such change the note data in sql without tab or in SSIS column delimiter.

thanks for you helps
Question by:tristonyip
    LVL 65

    Accepted Solution

    >there is a Text column  with a tab space, and when i try to export that Text column, the tab cause the problems.
    So, your only options here are
    Remove the tabs from the data via REPLACE(your_column, CHAR(9), ' '), or
    Change the delimeter to something that is not in the data, such as pipe |

    Author Comment

    i got this error when i try to run replace function, thanks

    Argument data type text is invalid for argument 1 of replace function.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video discusses moving either the default database or any database to a new volume.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now