vendredi 27 février 2015

SSIS Export Ragged Right Fixed Width format File


I created a ssis project to export a fixed width file to an external system. This file has 12 fields and they all position correctly per the external system requirements. I use Ragged Right format because this file can have hundreds of records and need them on there own line. Somehow when loading this file into the external system it fails. The strange thing is that if i delete a space at the end and then try to reload this file into external system it works. Is Ragged Right format causing an extra column? What can i do to fix this?





Aucun commentaire:

Enregistrer un commentaire