Send email task error
-
Friday, February 08, 2013 8:29 AM
Hi all,
I need to get the row count of a table and send an email.
I followed the following steps:
1 .Created a variable "Count" of type interger and scope is package.
2. Dataflowtask --> ODBC source - --> row count transformation.
3. Send email task... Getting the following error:
Error: Failed to lock variable "(DT_STR, 50, 1252) @[User::Count] " for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".
[Send Mail Task] Error: An error occurred with the following error message: "Failed to lock variable "(DT_STR, 50, 1252) @[User::Count] " for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.". ".
Added the screen shot for the refernce ..Pleas help me to sort out
All Replies
-
Friday, February 08, 2013 9:27 AM
Ok one thing in message source
if it expression then write that expression in the expression tab and change the expression (DT_WSTR,50)(@[User::Count])
Regards,
Eshwar
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.
- Marked As Answer by prasath_s01 Friday, February 08, 2013 9:58 AM
.png)
