Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-10-16 : 15:07:16
|
| I have used a Sequence Container as a precendence to the Send Mail Task.Flow is this way:Data Flow Task -----> Failure ------> Sequence Container (which has 3 Execute SQL Tasks) ------> Send Mail Task.Even Script Task as Event Handlers (On error and On post execute)I have an intentionally set error in the Data Flow Task.The Data Flow Task turns red because of the error, then the Sequence Container turns green, but the Send Mail Task shows an error.Error: The variable User::Variable contains a string that exceeds the maximum allowed length of 4000 characters. Error: Reading the variable "User::Variable" failed with error code 0xC0047100. The reason that I feel for the error is that the Error Message from the Sequence Container is looped many times and even though there is just one error, the Sequence Container is passing the same line of error multiple times. So, it says in the error that the Subject matter has exceeded the number of characters, which is not true.Can anyone of you please tell me how can I remove looping that is occurring in the sequence container? I am stuck here, so please let me know.Thank you.- notes4we |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-17 : 07:33:04
|
| Try setting User::Variable with Parameter Size = -1 (unlimited) |
 |
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-17 : 09:25:39
|
| Sorry for my ignorance, but setting parameter size to -1, you mean in the value field? Which is while creating a new variable or anywhere else?I am exactly not sure where to set that parameter size?Just to mention here, that I am using this user variable in a script task.Thank you. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-17 : 13:31:42
|
| Is there any error if you execute each SQL Task?Is User::Variable package level or Sequence container level? If in Script Task assignment, perhaps clear the variable first? |
|
|
|
|
|
|
Sequence Container Issue