I ran into an issue last night where copying selected text into the Execute SQL Task within SSIS would get truncated at a certain point. I really believe that I’ve successfully pasted larger text without an issue before, but I haven’t tested that theory as of yet.
One fix is to save the file as .sql and browse to it from within the Execute SQL task. Once I tried this I noticed that my last few lines were finally there. If you know of other ways around this please feel free to share.