SSIS_Staging doubt

  • hi, i got my csv files from source n am preparing datamart. here am facing a prblm.

    i have prepared all the tables of mart, when am trying to execute the task, some files are succesfully entered into destination db some are not,

    1.the error is column metadata validation is failed

    2.failure inserting into readonly column salesorderid

    3.one or more component failed validation

    can anybody tell me, what the prblm is?

  • priya.pk20 (10/17/2011)


    hi, i got my csv files from source n am preparing datamart. here am facing a prblm.

    i have prepared all the tables of mart, when am trying to execute the task, some files are succesfully entered into destination db some are not,

    1.the error is column metadata validation is failed

    2.failure inserting into readonly column salesorderid

    3.one or more component failed validation

    can anybody tell me, what the prblm is?

    1. refresh your data sources and transformations related to the data source, opening them up is usally enough to refresh the meta-data.

    2. Dont insert into a read-only? colum, i assume this is auto int?

    3. find the component, it should be in the error and open it up, it may just need a meta-data refresh

  • Thank you so much..:-)

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

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