FileCheckLogtargetframework

467AAcquireConnectionsmethod,226,235Asymmetricencryption,273BBIMLScript,SSISpackage,436executepackagetask,437integervariable,437masterpackage,446.
NETcode,439OLEDBconnectionmanagers,437packagetag,437SolutionExplorer,438stagedatabase,435transformations,438Breakpoint,46CColumntransformationclassvariables,335codeimplementation,335dataviewers,338InputColumnspage,334transformationtype,333CommonLanguageRuntime(CLR),55Connectionmanagertype,236C#orVB.
NET,30CreateNewOutputRowsmethods,229–230,235CryptoStreamMode,276CustomtaskAssemblyname,387BuildActionproperty,389BuildEventspage,389controlflow,385Defaultnamespace,387ExpressionBuilder,406codeimplementation,408formcontrols,407references,407usings,407formlayout,396addvariables,401closeeditorandsavechanges,404codeimplementation,397connectionmanager,402FindVariablemethod,400GUIDvariable,399interfaceclass,405PageLoadmethod,398taskHostproperty,397GAC,387PublicKeyToken,388RuntimecodeDtsTasktag,391executioncode,394IDTSComponentPersistinterface,395taskproperty,391Validatemethod,392SSISreferences,387VisualStudioprojects,386CustomtransformationAssemblynameandDefaultnamespace,413BuildEvents,416ClassLibraryprojects,412fordataflow,411DtsPipelineComponentcustomtransformationform,424DeleteOutputmethod,424executioncode,422inputandoutputports,418PerformUpgrademethod,423PreExecutemethod,422properties,417Validatemethod,420FormCodeConnectionsandVariables,425FormLoadmethod,426Index468IDtsComponentUI,428IServiceProvider,425icons,415keyfile,414publickeytoken,414SSISreferences,413DDesign-timeerror,392DtsPipelineComponent,417EErrorhandlingthrowstatement,65try-catch-finallystatement,66try-catchstatement,66Exception,45FFileSystemTaskoperationcopying/movingfiles,115–116CreationTimeandCreationTimeUtc,119errorcatching,118filename,extension,andpath,118file'ssize,119FireInformationtext,119–120ForeachLoopContainer,121ADOenumerator,137archivingfile,140csvfiles,133dataflowschema,140DataSetobject,135datatable,136fileconnectionmanagerconfiguration,139filelistpackagevariable,136FileLoadLogtable,144loadingfiles,135–136parametermapping,142SQLtaskconfiguration,141variables,133–134GetAccessControlmethod,119GetAttributesmethod,119lockedfiles,124FileStreamtype,127ScriptTask,126variables,125loopstructure,123methodsandproperties,118movefile,128controlflowschema,132FileCheckLogtable,129,133lockedfile,132logentry,130OLEDBconnection,131parametermapping,131SQLTaskEditor,130NETscripts,116properties,117read-onlyflags,116ScriptTask,121–122TimeSpanobject,123TimeSpanobject,124ForeachLoop,regularexpressions,195codeimplementation,197PassRegex,196precedenceconstraint,199RegexFilter,196ScriptTask,196testing,200FrameworkClassLibrary(FCL),55GGlobalAssemblyCache(GAC),93,167,201HHashingcodeimplementation,342dataflow,339dataviewers,348InputColumns,341OutputColumns,342ReadOnlyvariable,340stringvariables,338I,J,KInput0_ProcessInputRowmethod,229,232L,MLoggingeventsFireErrorresult,237FireInformationresult,239FireProgressresult,239–240FireWarningresult,238firingevents,237loopconstruction,239Progress/Executionresultstab,237unexpectederrors,238VB.
NETcode,238Customtransformation(cont.
)469N.
NETFrameworkarraysaccessingarraymembers,61initialization,60types,59classesandnamespaces,58collections,61components,55datatypeselements,57in.
NETandSSIS,55errorhandlingthrowstatement,65try-catch-finallystatement,66try-catchstatement,66generics,62lists,61loopsfor,63foreachloop,64whileloop,62operators,57using/importskeywords,58variables,57.
NETlibrary,30.
NETversionsC#-targetframework,240SSISversionsandframeworks,240VB.
NET,241OOLEDBcommand,295P,QPackageDeploymentmodel,449addreference,450App.
configfile,456btnStart_Clickmethod,452,455executemethod,456formcreation,451logging,454windowsapplication,450PassRegex,196PostExecutemethods,40,228,232,323PreExecutemethods,40,227,232,235,323,422ProcessInputmethod,422ProjectDeploymentmodeladdreference,457codeimplementation,460formcreation,458logmessages,464onClickeventhandler,459results,465RReadOnlyVariablemethod,231ReadWritevariablemethod,231Real-worldscenarios,195encrypt/decryptfiles,207codeimplementation,209ConnectionManager,208ScriptTask,208variables,208ForeachLoop,regularexpressions,195codeimplementation,197PassRegex,196precedenceconstraint,199Regexfilter,196RegexFilter,196ScriptTask,196testing,200Ionic.
Zip.
dll,201unzipping,201addreferences,202codeimplementation,203ControlFlow,202script,203zippingcodeimplementation,205reference,205RegexFilter,196Regularexpressions,311cleaningandvalidatingrulescodeimplementation,324dataviewer,325DFT_CleanseDate,322SCR_CleanseDate,322emailvalidationcallmethod,318cleaninterface,316dataviewers,318FlatFileConnectionManager,313scripttasktransformation,315SCR_ValidateEmail,314VSTAeditor,316pattern,311processingtext,311Regexclass,312removeHTMLtagscodeimplementation,320dataviewer,322DFT_RemoveHTML,319replacemethod,321Scr_RemoveHTML,319470requirements,312ReleaseConnectionsmethod,227RowNumbermethod,231SScriptComponent,37,243breakpoint,50connectionmanagers,235,299datatype,39debugging,46DebugView,54editor,32dataflowtask,219fileconnectionmanagers,222inputcolumnspage,220inputsandoutputs,221RowNumbercolumn,222scriptlayout,223scripttaskeditor,220errormessage,43fileconnectionmanager,295FlatFile,37Input0_ProcessInputRowmethod,39,302integervariable,230loggingevents,237messagebox,52.
NETversions,240PostExecutemethod,301pre-andpost-methods,40PreExecutemethod,300ReadOnlyVariablesandReadWriteVariables,231SSISpackage,441starterpackage,296surrogatekey,42textfile,303transformationtype,38types,297usages,43variabledispenser,232variables(andparameters),230watchfunctionality,51XMLfileconnectionmanager,306employeeattribute,308errorhandling,309fileconnectionmanager,303inputcolumns,305PostExecutemethod,308scriptcomponent,304types,304XMLstructure,307XmlTextWriternamespace,307ScriptComponentsourceconnectionmanager,253CreateNewOutputRowsmethod,263createRandomString,260dataflowtask,244,250–251DateTimepickRandomDate,261fileconnectionmanager,246–247flatfileconnectionmanager,243–244NumberOfColumnsintegervariable,257outputcolumns,252,259RandomMethods,261ScriptTransformationEditor,245source,transformation,anddestination,258VB.
NETcode,247,254,260ScriptComponenttransformation,267APRESS_SSIS_Scriptingdatabase,268comparerows,279DataAccessmode,279dataviewer,282inC#version,281OLEDBSource,280inVB.
NET,281conditionalmulticastconfiguration,290datasource,289dataviewer,292derivedcolumn,292PreExecuteandPostExecutemethods,291encryptanddecryptdata,272CryptoStream,276decryptiondata,277Editorpage,275encryptiondata,277OLEDBsource,273passwordsalt,276ReadOnlyvariable,274Scriptbutton,275GUIDcreationpackages,286RowGUID,287Input0_ProcessInputRowmethod,270IsNumericmethod,282FlatFileConnectionManager,283int32.
TryParsemethod,284Propercasing,271ReadWritevariables,270results,288SCR_TRA_ProperCasing,269StrConv,268surrogatekeys,284synchronousinput,268VSTAeditor,288ScriptLayoutAcquireConnectionsmethod,226classdeclaration,225Regularexpressions(cont.
)471CreateNewOutputRowsmethod,229directives,225environment,224Importstatements,225Input0_ProcessInputRowmethod,229namespaces,225PostExecutemethod,228PreExecutemethod,227ReleaseConnectionsmethod,227VB.
NETcode,225VSTAeditor,224ScriptTask,33assembly,88buildevents,93classlibrary,89creation,89GAC,93keyfile,92namespace,90publicstaticmethod,90references,95breakpoint,48connectionmanagers,98AcquireConnectionmethod,101ADO.
NETConnection,101ConnectionStringproperty,99ExcelFilePathproperty,100loggingevents,106Mainmethod,99OLEDBconnection,103debugging,46defaultlanguage,70editor,31,69errormessage,43,49exception,46FireCustomEvents,109childpackage,110codeimplementation,113eventhandler,113execution,114parentpackage,111packagedesign,33programminglanguage,33readonlyvariable,77readwritevariable,77testing,36usages,43variabledispensermethodadvantagesanddisadvantages,88codeimplementation,83parentpackage,88variables,77VB.
NETcode,74classdeclaration,75importstatements,75mainmethod,76namespace,75resultdeclaration,76SSISversion,75VSTAeditorProperties,72ScriptMain,72SolutionExplorer,72SSISversion,73VSTAenvironment,34,48watchwindow,49SimpleObjectAccessProtocol(SOAP),175SMTPConnectionManager,145dataflowtask,147,152flatfilesource,151FTPserverListDirectoryDetails,157–158,160,162–164SSISstringvariables,155–156VSTAenvironment,156HTTPconnectionmanager,153–154servername/IPaddress,145SFTPserver,165customNamespaces,171–173read-onlylock,167SFTPassembly,167–168SFTPconnections,171variables,166VSTAenvironment,168–170stringvariables,146URL,152VB.
NETcode,148–150VSTAenvironment,147SoftwareDevelopmentKit(SDK),360SQLServerDataTools(SSDT),3SQLServerIntegrationServices(SSIS),3SSHFileTransferProtocol(SFTP),69SSISandscriptingcolumnmappings,17ControlFlowlayout,21ControlFlowtasks,5–6C#orVB.
NET,30csvFileintoDatabase,11dataflowdesignpane,7–8DataFlowlayout,23DataFlowTask,22destinationcomponents,11drag-and-drop,18DTS,3filesystemtaskeditor,24flatfileconnectionmanager,13–14flatfilesource,13ForeachFileEnumerator,20ForeachLoopContainer,18.
NETlibrarylimitations,30.
NETscripting,25472controlflowlayout,29.
csvfile,26scripttaskeditor,27–28OLEDBconnection,15OLEDBdestinationeditor,16sourcecomponents,9SSDTdevelopmentstudio,4SSDTorBIDS,12transformationcomponents,10VariableMappings,21SSISpackageBIMLScript(seeBIMLScript,SSISpackage)programaticcreation,433ScriptComponent,441SSISToolbox,4StartingSequencemethod,230StartingSequencevariable,231Surrogatekeys,284Symmetricencryption,273T,Uelement,185VVagueerror,45VisualStudioforApplications(VSA)editor,223environment,224voidPostExecute()function,301WWebservices,349addservicereferencedialog,177–178binary-encodedcommunication,176built-inwebservicetask,176config/notconfig,179debugging,180DynamicsCRMdataflowdesigns,357deletemethod,370guidelines,357inputcolumns,361insertmethod,366IOrganizationServiceclassvariable,364latebindingmethod,365namespaces,363PreExecutemethod,364references,362ScriptComponent,361SDK,360updatemethod,368variables,360WindowsIdentityFoundation,360in-codemethod,181methods,properties,signature,interfaces,178publicweatherclassvariables,354dataviewer,356inputcolumns,350namespaces,354outputcolumns,351PostExecutemethod,356PreExecutemethod,355Input0_ProcessInputRowmethod,355ScriptComponent,350ServiceReference,353System.
ServiceModel,352variables,349SharePoint,371CreateNewOutputRowsmethod,376customnamespaces,374GetListItemsmethod,379helpmethod,378PreExecutemethod,376,379ScriptComponent,372ServiceReference,373SRC_TRA-GetExcelDocuments,377variables,372System.
ServiceModel,179variables,177WCF,175–176WCFprotocolchart,176WindowsCommunicationFoundation(WCF),175–176WorldWideWebConsortium(W3C),175X,Y,ZXMLconnectionmanager,188–189customnamespaces,189destination,327inInternetExplorer,332namespaces,328PreExecutemethod,328–329ProcessInputRowmethod,330ForeachLoopContainer,184–185ScriptTask,189ValidateXML,191variablemappingspane,186XMLschema,187–188SSISandscripting(cont.
)