If you are using SSIS to handle a column that has the name of ErrorCode you could run into an issue. You can find more information on the specifics @ Microsoft Connect. Your error may look similar to this: Validation error. Data Flow Task: DTS.Pipeline: The package contains two objects with the duplicate name of [...]

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 [...]