SQL Server Performance

issue with ssis load default value

Discussion in 'SQL Server 2005 Integration Services' started by comiccrazy, Aug 6, 2007.

  1. comiccrazy New Member

    Hi guys,

    when I create table, I create default value 'N/A'
    when some column is empty, it will automatic update this column to N/A
    value.

    the problem is ,it works when I manually insert data, but When I load
    data by SSIS(fast load), it doesn't work at all.
    Is there any body have idea what is the problem?

  2. satya Moderator

    What happens when it doesn't work, any error?
  3. comiccrazy New Member

    no error at all, load process is successful complete. but it does not load default values.
    Thanks
  4. dineshasanka Moderator

    Default value for when you have not specified any values .
    Have you specified any values from the SSIS at least a space or NULL
  5. comiccrazy New Member

    I am not so familiar with SSIS,
    just drag OLEDB source and destination, map the column, did not change other configuration.
    do I need to specify the column? where? how ?
    Thanks
  6. dineshasanka Moderator

    go to mappings
    and delete the link between those fields

Share This Page