SSIS packages programmatically with c# exception

Question

Hi,

I get an error calling the method: Badinstance.ReinitializeMetaData();, What could be the reason?
I want to point out that this is only in the SQL 2019 version.

                // Add Flat File error component  
                IDTSComponentMetaData100 BadCM = BaddataFlowTask.ComponentMetaDataCollection.New();  
                BadCM.ValidateExternalMetadata = false;  
                
                BadCM.Name = "BadError";  
                BadCM.ComponentClassID = "Microsoft.FlatFileSource";  
                CManagedComponentWrapper Badinstance = BadCM.Instantiate();  
                Badinstance.ProvideComponentProperties();  
                if (BadCM.RuntimeConnectionCollection.Count > 0)  
                {  
                    BadCM.RuntimeConnectionCollection[0].ConnectionManagerID = connectionManagerErrorFlatFile.ID;  
                    BadCM.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(connectionManagerErrorFlatFile);  
                }  
                Badinstance.AcquireConnections(null);  
                try  
                {  
                    Badinstance.ReinitializeMetaData(); // HERE  
                }  
                catch (Exception ex)  
                {  
  
                }  
                Badinstance.ReleaseConnections();  
  

Answer 1

Looking up the SSIS error here indicates that it is trying to load something that requires a code page but no such value is given.

Looking at the method you're calling it appears to be only used when validation fails because metadata is invalid. It also appears that it should be called automatically and not something you should be calling yourself. Finally, based upon what the metadata it seems like it is really only for design time support as validation runs at design time, but I'm not completely sure. Is there a reason you need to call this method?