Problems with ODBC Source
Hi Hi have a problem generating a package with an ODBC source. After I have generated the package and try to execute it, the execution will fail. Fail with the following error: [SSIS.Pipeline] Error: "ODBC_SRC DWVTT" failed validation and returned validation status "VS_NEEDSNEWMETADATA". After I go to my ODBC source in my DataFlow task and do "Show Advanced Editor" -> "Refresh" the package will work. When I compare the XML between a package that I have refreshed and not I see this (See attachment). Changes: CodePage is added after a refresh. Datatype change from wstr -> to str after refresh. Datartype change from dbTimestamp -> dbDate after refresh. The correct types in this case are str and dbDate. So the datatypes are changed for the better. But why are they detected wrong in the first place and what can I do about it?