2 Replies Latest reply on Oct 2, 2014 8:36 AM by ldms_4mfe

    Data Translation Services - Import Data - Import Empty or NULL Data Fields

    ldms_4mfe Apprentice

      Hello,

       

      we are Importing additional Information about our Assets from a SQL-Database.

       

      For example a Comment!

       

      The Import of all Comments to a asset works fine.

      If we change the comment the change is imported as well too.

      But if we delete the comment the change will not be Imported.

       

      I tried many types of transform the result with vbscript. But DTS seems to ignore the empty/NULL Fields in the SQL-Database.

       

      Examples for the vbscripts I tried:

       

      If len(value) < 1  then

      retvalue = "empty"

      else

      retvalue = value

      end if

       

       

      If value=Null  then

      retvalue = "empty"

      else

      retvalue = value

      end if

       

       

      If ISNull(value) then

      retvalue = "empty"

      else

      retvalue = value

      end if

       

      The Comment is only an Example we have a lots of other fields that should also be imported.

       

      Help would be highly welcome