DTS Package Imports NULL values | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Package Imports NULL values

Hello – I created a DTS package to import 2 columns into a Database table. The table is defined as ClientEmail (ClientID varchar(255) NOT NULL, ClientEmail varchar(255) NOT NULL). The Excel spreadsheet that I am importing from has no NULL value cells. But, when I run the DTS package only the numeric Client ID values get loaded correctly. All ClientID values that have alphanumeric characters seem to get loaded as NULL ClientID values in the table. Why is this happening?
This may be delayed answer,
But I have suggestion, Clcik the preview button and check whether you are getting all the data. If possible can you send that sample data set of the excel file to me. Then I can check.
quote:Originally posted by vn Hello – I created a DTS package to import 2 columns into a Database table. The table is defined as ClientEmail (ClientID varchar(255) NOT NULL, ClientEmail varchar(255) NOT NULL). The Excel spreadsheet that I am importing from has no NULL value cells. But, when I run the DTS package only the numeric Client ID values get loaded correctly. All ClientID values that have alphanumeric characters seem to get loaded as NULL ClientID values in the table. Why is this happening?
]]>