21

We really need more control over the true schemas used by SSIS in data management.  We need the ability to view as well as control the schemas further.  We have had a variety of situations throughout the process of the project implementation and in production where data management recurring integrations will fail and we find out that SSIS is complaining about schema validations.  But we cannot verify this to be accurate or not since we have no access to the schema.


As an example, we had been integrating a composite entity file with a single child entity for some time.  Sometimes, the file would have the child entity and sometimes it would not.  This was fine but when we applied Platform Update 5, this ceased to work and would only process the file if it had at least once instance of the entity.  This certainly has to be something that can be controlled in a schema file and was something we at least could view in AIF in 2012.  Please provide more visibility and control into the schema files used by SSIS

Category: Data Management
STATUS DETAILS
Declined
Ideas Administrator

Thanks for sharing this insight. As you are probably aware, we are working on data feeds as the next gen import/export capability. This situation should not happens since SSIS will not be used in data feeds.