The external columns for IT_packages data are out of syn with the data source

  • Hi

    I have a package in SSIS that on the latest ETL started giving the error message in the control flow. in the data flow it has:

    The metadata of the following output columns does not match the metadata of the external columns with which the output columns are associated:

    Output "excel source output": "column1", "column2" etc.

    Do you want to replace the metadata of the output columns with the metadata of the external columns. if I say yes it loads the end date as all NULLs.

    One of the columns in the output excel source is a data column and prior to this message the date was loading into the table as date and nulls which was correct. After this change the date column in the table is only loading as NULL and i need to use the date in reporting. Can anyone help me with suggestions on how to change the metadata so the date still comes into the table as date and nulls. Can you put into simple language what i need to do.

    Thank-you in advanced Phen

Viewing 0 posts

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