Post reply

Data Transformation Task in SSIS

  • August 30, 2007 at 12:12 am

    #118334

    Hi,

    How I set the Transform Data Task Property in SSIS package

    As I designed SSIS where I mapped my text file columns to database table columns but if I selected wrong input text file having less columns than database table then how I will come to know that it will not found remaining columns

    suppose my DB table contain 3 columns and my (wrong) text file contain 2 columns then i should get error message that column003 is not found????

    where i will get that setting

    please help me out

    T.I.A

  • August 31, 2007 at 6:53 am

    #730744

    Use a Conditional Split tool to check to see if a field is null. You can direct those records with null fields down another path that will let you fix the null fields, or put them in a table to be fixed later.

    Regards,

    Carla Hepker
    Documentation: A Shaft of light into a coded world.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply