Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Data Flow Task - Converting DT_NTEXT To DT_STR

1,559 views
Skip to first unread message

lloyd...@gmail.com

unread,
Jul 12, 2007, 9:31:52 PM7/12/07
to
Hi Guys,

I'm currently using SSIS to copy data from a source table, change some
of the datatypes and pump it into a destination table.

The problem I'm facing is with conversion of an NTEXT field to a
VARCHAR field in the destination.

What I'm doing right now is:

Step 1: Extract From Source (OLE DB Source). The data comes in as
NTEXT
Step 2: Data conversion from DT_NTEXT to DT_TEXT
Step 3: Data Conversion from DT_TEXT to DT_STR
Step 4: Pump into destination VARCHAR column (OLE DB Destinations)

The above works, but i dont think its the neatest way to do it.

I was wondering if anyone could help me combine step 2 and step 3 into
a single step.. or if there is a better way that I'm supposed to use
to convert ntext to varchar.

Any help would be really appreciated.

Thanks in advance.

Cheers, Lloyd

Allan Mitchell

unread,
Jul 13, 2007, 2:46:23 AM7/13/07
to
Hello lloyd...@gmail.com,

The way you are going is the way to do it using the Derived Column Transform.
The page

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d4e915cc-1c7b-4b2e-93b0-13a8b0cb9242.htm

Shows us that DT_NTEXT to DT_STR is an illegal cast so we have to go through
the step of DT_TEXT

So in a Derived Column transform I might do this for a column named "Val"
that is DT_NTEXT

(DT_STR,20,1252) (DT_TEXT, 1252) [Val]


--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

lloyd...@gmail.com

unread,
Jul 13, 2007, 3:50:47 AM7/13/07
to
Hi Allan,

Thanks for much for the help. :)

Cheers, Lloyd

On Jul 13, 2:46 pm, Allan Mitchell <al...@no-spam.sqldts.com> wrote:
> Hello lloyddsi...@gmail.com,


>
> The way you are going is the way to do it using the Derived Column Transform.
> The page
>
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d4e915cc-1c7b-4b2e-93b0-13a8b0cb9242.htm
>
> Shows us that DT_NTEXT to DT_STR is an illegal cast so we have to go through
> the step of DT_TEXT
>
> So in a Derived Column transform I might do this for a column named "Val"
> that is DT_NTEXT
>
> (DT_STR,20,1252) (DT_TEXT, 1252) [Val]
>
> --
>

> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com

sneha

unread,
Mar 30, 2010, 9:04:13 AM3/30/10
to
hi

From http://search.yahoo.com/search?p=>+ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d4e915cc-1c7b-4b2e-93b0-13a8b0cb9242.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

0 new messages