Hi All, I have a package which is running on prod server and is failing with the error shown as below when i opened the package in the BIDS. Basically the package has a dataflow task which uses a Openquery to pull data of one day from a Infromix db tables and then dumps the data in a flat file . The error is pointing to 2 columns "date", "id". I know that I need to correct the data type issues with the columns affected but can you suggest me the best possible way to handle this and fix the package I also wanted to know when prompted to click yes should I just click yes and build the package and redeploy it. Error: TITLE: Microsoft Visual Studio ------------------------------ The metadata of the following output columns does not match the metadata of the external columns with which the output columns are associated: Output "OLE DB Source Output": "date", "id". Do you want to replace the metadata of the output columns with the metadata of the external columns? Mudassar

Source columns in Informix colname coltype collength id 274 10 date 266 3594 Mudassar

The package failed because the metadata of the source was updated and hence it made the metadata with which your package was configured invalid. Press Yes on the message pop up and SSIS will auto fix the metadata of the source component.http://btsbee.wordpress.com/

External columns- which are coming from source informix had changed datatype date: datatype -database timestamp [DT_DBTIMESTAMP2] id:datatype - eight-byte signed integer [DT_I8] My Package configuration for the columns had the following data types date: datatype - database timestamp [DT_DBTIMESTAMP] id:datatype - four-byte signed integer [DT_I4] When the package data flow task prompted me to click yes .I clicked yes and it got corrected. Thanks MudassarMudassar