sql server dts: Transform Data Task From Excel Yields NULL Column -- sql server dts

Transform Data Task From Excel Yields NULL Column

Henry Berry
11/8/2007 12:35:53 PM

sql server dts:

I have a dts package that imports data from an Excel sheet directly into a table. One of the columns which has data in the Excel file yields all null values in the table.

I have found that using the delete key in any cell in the column can cause this. What I don't know is how to get around it.

From http://www.developmentnow.com/g/103_0_0_0_0_0/sql-server-dts.htm

Posted via DevelopmentNow.com Groups

RE: Transform Data Task From Excel Yields NULL Column

Henry
11/9/2007 6:06:56 AM

I found that this issue is caused by how Excel decides the data type in the column. If Excel determines the data type of the column to be text then it will not export numbers. What I am looking for now is a way around this if it is possible.

Thank You
Henry

From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=103&threadid=1035092

Posted via DevelopmentNow.com Groups