If an Execute SQL Task fails with this error, there are two things I recommend checking.
First, do you have a timeout specified. If you specify a timeout other than 0, then when that time elapses the Execute SQL Task may fail with this error. A timeout period of 0 means infinity. You can set the timeout period by editing the Execute SQL Task. You’ll see Timeout right under the options section.
Second, if you are inserting information into a table using the SQL INSERT command, be sure the columns in your table are big enough to hold the data. For example, I had a column of type nvarchar(75) but the data I was trying to insert had a length of 78. Be sure to make sure datatypes match up as well.
JamesNT
