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