Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Dts tranfer using text datatype - Transform carrage returns
0 views
Skip to first unread message
Ross Lourensse
Nov 21, 2001, 7:21:20 PM11/21/01
to
I am trying to export (using DTS) an MSSQL 7.0 table into a flat file
(delimited; colomns, vertical bar, text, single quotes). In this table,
there are a few Text datatype fields that contain "Carriage Returns". The
result of the export in the flat file is that the Carriage returns are
replicated so the Memo fields show up in more than one line, which I don't
want.
(delimited; colomns, vertical bar, text, single quotes). In this table,
there are a few Text datatype fields that contain "Carriage Returns". The
result of the export in the flat file is that the Carriage returns are
replicated so the Memo fields show up in more than one line, which I don't
want.
The application package I customize and that looks up to the MSSQL
database
(called HEAT, from FrontRange) offers an Import/Export module that
transforms the carriage returns into \r\n ASCII characters. But, the
module
doesn't provide any scheduling feature, which I absolutely need.
Is there any way I can get the same result with DTS and have the entire
records show up in only one line each?
Robert Lummert
Nov 22, 2001, 5:58:05 AM11/22/01
to
...
transforms the carriage returns into \r\n ASCII characters. ...
...
create temp table using
select ..., REPLACE( yourMemoField, CHAR(13) + CHAR(10), '\r\n'), ...
into tempTable
from yourTable
Ramesh
Nov 23, 2001, 6:31:50 PM11/23/01
to
create veiw vwtemp as
select ..., REPLACE( yourMemoField, CHAR(13) + CHAR(10), '\r\n'), ...
from yourTable
select ..., REPLACE( yourMemoField, CHAR(13) + CHAR(10), '\r\n'), ...
and then use the view as input table in the dts.
Robert Lummert <r...@w4u.com> wrote in message news:<3BFCDA3D...@w4u.com>...
0 new messages