Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 NULL ISSUE

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-05-07 : 11:14:35
Dear All,
I am importing the data from Flat file to a table having 10k of records (file type of .csv).IN the flat file i do not see any NULL values but when i import it to a table its having some 2k rows of NULL for perticular column.
IN the destination connection manager i kept keep nulls unchecked.

Pls help me to identify the exact issue.

Thanks,
Gangadhar

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-07 : 13:50:27
whats the data type of destination field? and what does source connection manager identify it as?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -