<div>
i got this error when i try to run replace function, thanks<br />
<br />
Argument data type text is invalid for argument 1 of replace function.
</div>


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

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

<div>
<div class="content wysiwyg-content">
hi <br />
&nbsp;i try to export some data to a text file by using SSIS, the problem is there is a Text column &nbsp;with a tab space, and when i try to export that Text column, the tab cause the problems. <br />
<br />
sample <br />
&nbsp;<br />
the table column [note]<br />
[note] [text] COLLATE SQL_Latin1_General_CP1_CI_<wbr />AS NULL,<br />
<br />
SSIS <br />
[note] text_stream[DT_text]<br />
and the column delimiter is Tab{t}<br />
<br />
is any way to avoid this, such change the note data in sql without tab or in SSIS column delimiter. <br />
<br />
thanks for you helps
</div>
</div>


hi 
 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. 

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

SSIS 
[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

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.