Column length metadata for external and output columns do not match
Hi, my source is ODBC connection and I am using DirectInput for definition of the source table.
<OdbcSource Name="ODBC Source" Connection="conn_02_SOURCE" ValidateExternalMetadata="true">
<DirectInput>SELECT * FROM dwh.ACCOUNT</DirectInput>
After generating SSIS problems with different column length occured.
Validation error. Load data from source to target ODBC Source : The ODBC Source.Outputs[Error].Columns[ACCOUNT_NO] on the error output has properties that do not match the properties of its corresponding data source column.
e.g. column ACCOUNT_NO is VARCHAR(100) in the source database
in generated SSIS is this same column VARCHAR(100) in Output/External Columns but VARCHAR(150) in Output/Outputs Columns as well as in Error/Outputs Columns.
The only workaround is to open the SSIS package, then open ODBC Source container and then remove and add all columns. After that column ACCOUNT_NO has this same length (varchar(100)) on all three places in SSIS package.
What I am doing wrong?