i wanted setup rds instance store data reporting. have scrips run different rest calls against sites require bulk admin privilege on end because dump rest call data csv , bulk csv insert sql server se. in local environment setting user scripts use bulk admin privileges easy. however, couldn't seem figure out how in rds. opened ticket amazon , suggested writing policy it. figured ask here if possible , possible alternatives? if bulk/system admin privileges out of question in rds guess have use aws ec2 instance sql server set on it.
bulk insert not possible rds. data_file parameter of bulk insert command must refer file accessible machine running sql server.
also, rds not support bulkadmin server role.
Comments
Post a Comment