0

Greetings - I need your help.

I have an SSIS package with a Data Flow Task which has the following Data Flow tasks: Excel Source -> Data Conversion -> SQL Server Destination .

The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.)

I'm trying to cast all data into strings and insert it into a SQL table, but the numerical data doesn't get inserted -- I get null instead.

I've casted the worksheet data to Unicode string [DT_WSTR] and mapped the casted fields to my SQL table but still get null for the cells containing numbers. All fields in the SQL table are varchar.

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by M_K_Higa
0

Greetings - I need your help.

I have an SSIS package with a Data Flow Task which has the following Data Flow tasks: Excel Source -> Data Conversion -> SQL Server Destination .

The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.)

I'm trying to cast all data into strings and insert it into a SQL table, but the numerical data doesn't get inserted -- I get null instead.

I've casted the worksheet data to Unicode string [DT_WSTR] and mapped the casted fields to my SQL table but still get null for the cells containing numbers. All fields in the SQL table are varchar.

I never found a case like this, it is because there is some data you type is not the same. try to check back your data

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.