I need to use a column with a sql_variant data type from a SQL Server 2000
table in a Data Flow Task without using the default conversion to DT_WSTR. I
would be willing to copy the sql_variant column contents to another column
with the appropriate data type, if possible.
Thanks,
Greg

Greg,
I just knocked together a package that did this and didn't find any
problems. I successfully converted the values from the sql_variant column
from unicode into a column of type DT_STR. It worked fine. The conversion
was done using a derived column component.

Of course, it depends on the values that you have as to whether it will work
for you. I don't envisage too many problems though.

Regards
Jamie Thomson
An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx


"Greg" <Greg (AT) discussions (DOT) microsoft.com> wrote

I always get a warning message "The output"OLE DB Source Output" (10)
references an external data type that cannot be mapped to a Data Flow task
data type. The Data Flow task data type DT_WSTR will be used instead." You
didn't get this I imagine. How?

I have columns with a float data type that won't be properly converted to
string without casting them using style number 2 (truncates).

"Jamie Thomson" wrote: