| Name |
Get_ArchivedFullSnapshot |
| Value |
 Expression: "EXEC usp_FactArchivedEnrollmentSnapshot_FullSelect '" + @[User::CurrentDayDate] + "' , '" + @[User::TermResults] + "'"
EXEC usp_FactArchivedEnrollmentSnapshot_FullSelect '2016-03-04' , '' |
| Value Type |
String |
| Description |
The SQL statement that will execute the stored procedure to extract the data from the archived Student Class Log file in the Source system. This variable is used during a Full Load. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::Get_ArchivedFullSnapshot |
| Evaluate As Expression |
True |
| Expression |
"EXEC usp_FactArchivedEnrollmentSnapshot_FullSelect '" + @[User::CurrentDayDate] + "' , '" + @[User::TermResults] + "'" |
| ID |
d8d28808-6728-4981-957b-9b62b1b25a3d |
| Raise Changed Event |
False |
Properties
