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?

    comiccrazy, Aug 6, 2007
    #2

  2. satya Moderator

    What happens when it doesn't work, any error?
    satya, Aug 6, 2007
    #3

  3. comiccrazy New Member

    no error at all, load process is successful complete. but it does not load default values.
    Thanks
    comiccrazy, Aug 6, 2007
    #4

  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
    dineshasanka, Aug 6, 2007
    #5

  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
    comiccrazy, Aug 6, 2007
    #6

  6. dineshasanka Moderator

    go to mappings
    and delete the link between those fields
    dineshasanka, Aug 6, 2007
    #7

Share This Page