Jul 21, 2009 at 9:56 AM
Edited Jul 21, 2009 at 10:11 AM
Thank you for your response.
I managed to get some further information regarding the issue.
When setting up the package in VS, the instructions specify to Mark the result set as a Single Row. However when executing the package in VS the package does not execute correctly. IF I change the ResultSet to none, the package executes but then the
Unit Tests fails.
If I change the ResultSet to SingleRow I get the following error in my SSISunit
Assert 21/07/2009 10:59:26 Package Get Table Count Get Table Count Task Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow". False
Test 21/07/2009 10:59:26 Package Get Table Count Get Table Count Exception occurred: Failed to lock variable "tableCount" 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.".