Geeks With Blogs
My Digital Life in Data Flow Data Warehouse, MDX, Cube, SSIS, BizTalk, SQL, XML, SSAS, SSRS, .NET December 2010 Entries
SSIS Send Mail Task and ForceExecutionValue Error
I tried to use the "ForcedExecutionValue" on several Send Mail Tasks and log the execution into a ExecValueVariable so that at the end of the package I can log into a table to say whether the data check is successful or not (by determine whether an email was sent out) I set up a Boolean variable that is accessible at the package level, then set up my Send Mail Task as the screenshot below with Boolean as my ForcedExecutionValueType. When I run the package, I got the error described below. Just to ......

Posted On Friday, December 3, 2010 11:34 AM

Copyright © Kevin Shyr | Powered by: GeeksWithBlogs.net | Join free