I trawled around trying to find out why my SQL Insert was not working. After some trial and error and good feedback from DataSprings I got to the final solution: INSERT INTO ND_Pupil_Ref (Ref_Name, Ref_Email, Friend_Name, Friend_Email, Inst_ID, Inst_Name) VALUES (N'$(RefName)', N'$(RefEmail)', N'$(FriendName)', N'$(FriendEmail)', N'$(Inst_ID)', N'$(Inst_Name)') Hope this helps other people