| Name |
SQL Remove Incremental Process Days from Fact |
| Description |
Execute SQL Task |
| Precedence Executables |
none |
| Contrained Executables |
none |
| BypassPrepare |
True |
| CodePage |
1252 |
| Connection |
EnterpriseDW |
| CreationName |
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 |
| DelayValidation |
False |
| Description |
Execute SQL Task |
| Disable |
False |
| DisableEventHandlers |
False |
| EventHandlers |
System.__ComObject |
| EventInfos |
System.__ComObject |
| ExecutionDuration |
0 |
| ExecutionResult |
0 |
| ExecutionStatus |
1 |
| ExecutionValue |
|
| FailPackageOnFailure |
False |
| FailParentOnFailure |
False |
| ForcedExecutionValue |
0 |
| ForceExecutionResult |
-1 |
| ForceExecutionValue |
False |
| ID |
{419F7389-EF28-4525-9B72-433BCB5994FD} |
| IsDefaultLocaleID |
True |
| IsolationLevel |
1048576 |
| IsStoredProcedure |
False |
| LocaleID |
English (United States) |
| LogEntryInfos |
System.__ComObject |
| LoggingMode |
0 |
| LoggingOptions |
System.__ComObject |
| MaximumErrorCount |
1 |
| Name |
SQL Remove Incremental Process Days from Fact |
| ParameterBindings |
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterBindings |
| Parent |
System.__ComObject |
| ResultSetBindings |
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ResultBindings |
| ResultSetType |
1 |
| SqlStatementSource |
User::Remove_ExistingEnrollActivity
|
| SqlStatementSourceType |
3 |
| StartTime |
3/9/2017 5:47:05 PM |
| StopTime |
3/9/2017 5:47:05 PM |
| TimeOut |
0 |
| TransactionOption |
1 |
| VariableDispenser |
System.__ComObject |
| Variables |
System.__ComObject |
| Version |
0 |
Properties
Expression: "
/* Remove Rows from FactEnrollmentActivity for the ETL Incremental Begin to End Dates */
DELETE FROM [dbo].[FactEnrollmentActivity]
FROM [dbo].[FactEnrollmentActivity] As EnrollActivity
JOIN [dbo].[DimDate] AS Dates
ON EnrollActivity.DateSK = Dates.DateSK
WHERE Dates.FullDate >= '" + @[User::IncrementalBeginDtTm] + "'
AND Dates.FullDate <= '" + @[User::IncrementalEndDtTm] + "'"
