Control Tables in SSIS

vG_Ins_Audit_C  ::

"EXEC [USP_Ins_Audit_C]                           

                     @SourceTableName   = '" + @[User::vG_SourceTableName]  + "'                            

                    ,@TargetTableName   = '" +  @[User::vG_TargetTableName]  + "'                            

                    ,@TotalRecieved   ="  +  (DT_WSTR, 10) @[User::vG_Audit_Received]  + "

                    ,@TotalInserted   ="  +  (DT_WSTR, 10) @[User::vG_Audit_Inserted]  + "

                    ,@TotalUpdated   ="  +  (DT_WSTR, 10) @[User::vG_Audit_Updated] +"

                    ,@TotalFailed  = "  +  (DT_WSTR, 10) @[User::vG_Audit_Failed] + "

                    ,@TotalErrors    ="  +  (DT_WSTR, 10) @[User::vG_Audit_Errors]  + "

                    ,@TotalWarnings  ="  +  (DT_WSTR, 10) @[User::vG_Audit_Warnings]  + "

                    ,@StartDateTime  =' " + (DT_WSTR, 50)  @[User::vG_Audit_StartDateTime] + " ' "  + "

                    ,@EndDateTime   = '" +  (DT_WSTR, 29) (DT_DATE) Getdate() + "'"  + "

                    ,@PackageName   =' " +  @[System::PackageName]+ " '     "+"

                    ,@ControlflowName   =   '" +  @[User::vG_ControlFlowName] + "    '" + "

                    ,@DataflowName   =      '" +  @[User::vG_DataFlowName] + "'" + "                          

                    ,@Created_By    =           '" +  @[System::UserName]+ "'"+"

                    ,@Source_System    =    '" +  @[User::vG_SourceSystem]  + "'          "

vG_Ins_Error_C  ::

"EXEC [USP_Ins_Error_C]   

                                 @PackageName  = "  +  "'" + @[System::PackageName]  + "' "  + "              

                                ,@ControlFlowName     = '" +  @[User::vG_ControlFlowName] + "'" + "

                                ,@DataFlowName           = '" +  @[User::vG_DataFlowName] + "'" + "       

                                ,@SourceTableName     = '" + @[User::vG_SourceTableName]  + "'         

                                ,@TargetTableName      = '" +  @[User::vG_TargetTableName]  + "'

                                ,@createdby                      = "+"'"+ @[System::UserName] +"'"+"

                                ,@ErrorType                      = 'OnError'

                                ,@ErrorMessage              = 'Error while updating the Date_D'

                                ,@SourceSystem             = '" + @[User::vG_SourceSystem]  + "'   “

 

vG_Ins_PackageHistory_C  ::

"DECLARE @PackageHistoryID INT  EXEC [USP_Ins_PackageHistory_C]                                                  

                 @PackageName     = "  +  "'" + @[System::PackageName] + "' "  + "

                ,@LoadStatus           = 'Running'                  

                ,@SourceSystem       = "  +  " ' " + @[System::PackageName] + " '  "  + "

                ,@TransactionDate   = ' " +  (DT_WSTR, 29)  (DT_DATE)    GETDATE() + " ' " + "      

                ,@CreatedBy              = "+" ' "+ @[System::UserName] +" ' " +"

                ,@PackageHistoryID  = @PackageHistoryID  OUTPUT

                SELECT @PackageHistoryID AS PackageHistoryID      "