Thank you snaghshineh, really appreciate your reply. Changed my DTS package a number of times thinking it was a temp table issue.