SSIS: Load Excel data to table

[M_K_Higa]

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.

[Ranap Manalu]

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

[M_K_Higa]

Folks - I found the answer. I needed to set the extended property IMEX=1 in the connection string. Here's a link that explained what I needed to do: http://msdn.microsoft.com/en-us/library/ms141683(SQL.100).aspx.