SQL Server Performance

Loading empty data with NULL from text file source??

Discussion in 'SQL Server 2008 Integration Services' started by apat, Jul 29, 2009.

  1. apat New Member

    Hi All,
    I have a text file with one column where some of the data is blank where some of the records have some values like 0.9, -2.3,3.0,4 etc. I am loading that to one Table in SQL Server 2008. For those records where there is blank(empty) it gets loaded as 0 in my Sql server table. What is the work around with this? I do not want that to be loaded as 0. I want that to be NULL or someother number etc
    My text files are on my local drive and I cant copy them to actual machine.
  2. moh_hassan20 New Member

    you can control this using bcp utility with -k flag
  3. apat New Member

    okay let me try this..Thanks

Share This Page