I interrogate some SQL server tables with (N)VARCHAR(MAX) columns. I read this metadata in, and generate BIML table scripts from that metadata. In this Biml, the Length shows -1. The problem comes when I later generate a package that reads these source tables with (N)VARCHAR(MAX). The packages that it generates throw validation errors.
Validation error. DFT-dbo-t_asap_flightcrew_reports SSIS.Pipeline: The "AdoNet_SRC-dbo-t_asap_flightcrew_reports.Outputs[Output].Columns[summary]" has a length that is not valid. The length must be between 0 and 4000.
If I manually refresh the source components with the advanced editor, the lengths update from -1 to 0. Then the package is good to go. Unfortunately, manually fixing hundreds of packages is a non-starter. Any ideas on how to fix this through Biml?
I interrogate some SQL server tables with (N)VARCHAR(MAX) columns. I read this metadata in, and generate BIML table scripts from that metadata. In this Biml, the Length shows -1. The problem comes when I later generate a package that reads these source tables with (N)VARCHAR(MAX). The packages that it generates throw validation errors.
Validation error. DFT-dbo-t_asap_flightcrew_reports SSIS.Pipeline: The "AdoNet_SRC-dbo-t_asap_flightcrew_reports.Outputs[Output].Columns[summary]" has a length that is not valid. The length must be between 0 and 4000.If I manually refresh the source components with the advanced editor, the lengths update from -1 to 0. Then the package is good to go. Unfortunately, manually fixing hundreds of packages is a non-starter. Any ideas on how to fix this through Biml?