How to write Amazon SQS Queue Attributes in SSIS

SSIS Amazon SQS Destination connector supports writing Custom Attributes along with your Queue Message. See below. Basically, Enter Attributes as a Comma-separated string in AttributeName field. Optionally You can also specify the datatype.

MyProp1=int,MyProp2=double,MyProp3,MyProp4

It will add new columns automatically in Target Mapping area (Prefixed with Attr_)

Specify Queue Message Attribute names 

 

Attribute Mappings