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