Getting an error with a union in SSIS, “The Metadata for union does not match the metadata for the associated output column.” Any ideas?
I am working with SSIS in Visual Studio 2019, and I am trying to do something fairly simple. In the data flow I load data from two flat files (basically, half the data set in each file), union them together, then after doing a few simple derivations and a lookup, I save the data to the database. The Data Flow looks like this: