MZ@ !L!This program cannot be run in DOS mode. $-TٽL:L:L:FL:BL:RichL:PELyK! vO"@@ux`.rsrcuv@@( h (@ X h x     xkNpPx8z0~@Tf HdCheckF[ile] filespec Optional. Name the checkpoint file when checkpointing is turned on. The filespec argument specifies the file name and path of the checkpoint file. Checkp[ointing] {on | off} Optional. Turn checkpointing on or off. Default is on if neither on nor off is specified. ,Com[mandFile] filespec Optional. Loads a text file that contains additional dtexec command options, prior to package execution. The filespec argument specifies the file name and path of the command file that you want to associate with the execution of the package. tConf[igFile] filespec Optional. Sets a run-time configuration that is different from the configuration that was specified at design time. You can store dtexec configuration settings in an XML configuration file and then load the settings by means of the ConfigFile option prior to package execution. Conn[ection] id_or_name;connection_string Optional. Sets the connection string property of a ConnectionManager stored within a SSIS package. The ConnectionManager is identified either by its name or its ID. L Cons[oleLog] [[DisplayOptions];{E | I};src_name_or_guid[src_name_or_guid[...]]] Optional. Displays all available log entries to the console during package execution, if no arguments are specified. If you omit this option, no log entries are displayed to the console during package execution. Valid display options are: o N (Name). Display the name. o C (Computer). Display the computer. o O {Operator). Display the user. o S (Source Name). Display the source name. o G (Source GUID). Display the source GUID. o X (eXecution GUID). Display the execution GUID. o M (Message). Display the message text. o T (Time). Display the date and time. Valid arguments are: o I (Inclusion List). Only the source names or GUIDs that are specified are logged. o E (Exclusion List). The source names or GUIDs that are specified are not logged. If you use multiple ConsoleLog options on the same command prompt, they interact as follows: o Their order of appearance has no effect. o If no inclusion lists are present on the command line, exclusion lists are applied against all types of log entries. o If any inclusion lists are present on the command line, exclusion lists are applied against the union of all inclusion lists. o The following table lists of all available source names and their associated GUIDs: TDT[S] package Loads a package using the SSIS Service. The package argument specifies the folder and name of the package to retrieve. However, you can use the DTS option in conjunction with the Server option. If you omit the Server option, the default local instance of the SSIS Service is assumed. If you use the DTS option in conjunction with any of the following options, dtexec fails: o File o SQL $F[ile] filespec Loads a package that is saved in the file system as a .dtsx file. The filespec argument specifies the path and file name of the package. You can specify the path as either a Universal Naming Convention (UNC) path or local path. If you use the File option in conjunction with any of the following options, dtexec fails: o DTS o SQL o User o Password o Server H[elp] [option_name] Optional. Displays a list of options and their associated arguments unless the option_name argument is specified. If you specify an option_name argument, dtexec displays the command line help for the specified option. 4L[ogger] classid_or_progid;config_string Optional. Associates a logger with the execution of a SSIS package. The following lists available loggers: Name ProgID/ClassID Text file DTS.LogProviderTextFile.1 {0A039101-ACC1-4E06-943F-279948323883} SQL Profiler DTS.LogProviderSQLProfiler.1 {E93F6300-AE0C-4916-A7BF-A8D0CE12C77A} SQL Server DTS.LogProviderSQLServer.1 {94150B25-6AEB-4C0D-996D-D37D1C4FDEDA} Window Event Log DTS.LogProviderEventLog.1 {071CC8EB-C343-4CFF-8D58-564B92FCA3CF} XML file DTS.LogProviderXMLFile.1 {440945A4-2A22-4F19-B577-EAF5FDDC5F7A} M[axConcurrent] concurrent_executables Optional. Sets the number of threads that process executables in a single package execution instance. By default, the number of processors plus 2 threads are allocated for package execution. HP[assword] password Optional. Allows the retrieval of a package that is protected by SQL Server Authentication. This option is used in conjunction with the SQL and User options. However, you can use the Password option only if you use the User option. If the Password option is omitted and the User option is used, a blank password is used. * Security Note: When possible, use Windows Authentication. Rem comment Optional. Places comments on the command prompt or in command files. The comment argument is optional. The value of comment is a string that either must be enclosed in quotation marks or contains no white space. <Rep[orting] level[;eventguid_or_name[;eventguid_or_name[;...]] Optional. The level may be N or V or any combination of E, W, I, C, D, and P. The optional list of event guids or names is a list of items to be excluded from the output when the message matches the level. If the level is N then the list contains items to be displayed even though reporting is off. If reporting is not specified then the default is EWP. Level N - Display nothing E - Display error messages W - Display warning messages I - Display information messages C - Display custom messages D - Display DataFlow messages P - Display progress messages V - Display all messages Res[tart] {deny | force | ifPossible} Optional. By default, Restart is set to force. Set property_path;value Optional. Overrides the configuration of a variable, property, container, log provider, foreach enumerator, or connection within a package. When specified, the /SET option sets the specified propertypath to the value given. Multiple /SET options can be specified. The following is an example of executing a package that is provided a variable with a value. dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue Ser[ver] server_name Optional. Specifies the name of SQL Server instance from which to retrieve the package. If you omit this option, package execution is attempted against the local default instance of SQL Server. tSQ[L] package Loads a package that is stored in SQL Server. The package argument specifies the folder and name of the package to retrieve. However, you can use the SQL option in conjunction with options User, Password, and Server. If you omit the User option, Windows Authentication is used to access the package. If it is present, the User login name specified is associated with SQL Server Authentication. You can use the Password option only in conjunction with the User option. If you use the Password option, dtexec accesses the package with the user name and password information that you provide. If you omit the Password option, a blank password is used. * Security Note: When possible, use Windows Authentication. If you omit the Server option, the default local instance of SQL Server is assumed. If you use the SQL option in conjunction with any of the following options, dtexec fails: o DTS o File U[ser] user_name Optional. Allows the retrieval of a package that is protected by SQL Server Authentication. You use this option in conjunction with the SQL option. * Security Note: When possible, use Windows Authentication. Va[lidate] Optional. Stops the execution of the package after the validate phase, without actually running the package. If you use the WarnAsError option elsewhere on the command line, dtexec fails if a warning occurs during validation. VerifyB[uild] major[;minor[build]] Optional. Verifies the build number of a package against the build numbers specified in the major, minor, and build arguments. If used, and a mismatch occurs, the package will not execute. You must use an argument with this option. The argument can have one of three forms: o major o major;minor o major;minor;build ,VerifyP[ackageID] package_id Optional. Verifies the ID of the package to be executed against the value specified in the packageID argument. VerifyS[igned] Optional. Causes the package to fail if it is not signed. <VerifyV[ersionID] version_id Optional. Verifies the version GUID of a package to be executed against the value specified in the versionID argument. W[arnAsError] Optional. Causes the package to fail if a warning occurs during validation. If no warnings occur during validation and the Validate option is not specified, the package is executed. XSu[m] Optional. Causes reported progress to show the total number of rows received by a component rather than number of rows currently being sent to the component. De[crypt] password Optional. Sets the decryption password used when loading a package with password encryption. Dump code[;code[;code[;...]]] Optional. Specify a list of SSIS event codes that will trigger the system to create debug dump files during package execution. The event code can be an error code, warning code, or information code. DumpOnErr[or] Optional. Create debug dump files when any error occurs during package execution. $VLog [Filespec] Optional. Writes all Integration Services package events to the log providers that were enabled when the package was designed. To have Integration Services enable a log provider for text files and write log events to a specified text file, include a path and file name as the Filespec parameter. If you do not include the Filespec parameter, Integration Services will not enable a log provider for text files and will write log events only to the log providers enabled for the package at design time. X86 Optional. Ignored when running dtexec from the command line. Use this option when scheduling a job with SQL Agent to specify that SQL Agent should use the 32-bit dtexec runtime to execute the specified package. DTExec is the command line package executer. To get more information on its usage specify the /help option on the command line. To get detailed help about an option specify /help option on the command line. 4VS_VERSION_INFOd@2 @?NStringFileInfo*040904B02 PlatformNT INTEL X86ILegalTrademarksMicrosoft SQL Server is a registered trademark of Microsoft Corporation. CommentsSQL&GoldenBitsTrueLCompanyNameMicrosoft Corporation@FileDescriptionData Transformation Services Execution Utility Parser Resourcest*FileVersion2009.0100.1600.01 ((KJ_RTM).100402-1540 )2 InternalNameDTEParsen%LegalCopyrightMicrosoft Corp. All rights reserved.B OriginalFilenameDTEParse.RLLJProductNameMicrosoft SQL Server> ProductVersion10.50.1600.1DVarFileInfo$Translation !Option index %1!d! is not valid. %Missing argument for option "%1!s!". 2Argument "%1!s!" for option "%2!s!" is not valid. +Option "%1!s!" can only be specified once. Option %1!d! is not valid. OAn out of memory error occurred while saving. Option: %1!s!, Argument: %2!s!. 7A type mismatch occurred in an argument set operation. YComparison of argument "%1!s!" failed against a previously set value for option "%2!s!". CAn unknown error occurred for option "%1!s!" with argument "%2!s!" eA command file option was encountered while in a command file. Nested command files are not allowed. RThe DTS option cannot be specified with the File, SQL, User, or Password options. ZThe File option cannot be specified with the DTS, SQL, Server, User, or Password options. AThe SQL option cannot be specified with the DTS or File options. <The Password option must be specified with the User option. YThe SQL option must be specified if the User, Password, or Server options are specified. AAt least one of the DTS, SQL, or File options must be specified. Option "%1!s!" is not valid. 5Reporting option V or N can only be specified alone. HReporting options E, W, I, C, D, and P can only be specified once each. XAn invalid reporting option was specified. Only E, W, I, C, D, P, V, and N are allowed. JAn invalid console logging option was specified. Only I or E is allowed. ;Console logging option "E" must have a list of exclusions. ;Console logging option "I" must have a list of inclusions. $Could not open command file "%1!s!" *Out of memory while saving Option: %1!s!. AConsole logging display options can only be specified once each. fAn invalid console logging display option was specified. Only N, C, O, S, G, X, M, and T are allowed. DAn out of memory condition occurred while parsing the command file. ,The argument "%1!s!" has mismatched quotes. Enter decryption password: Enter SQL Server password: 5 Usage: DTExec /option [value] [/option [value]] ... XOptions are case-insensitive. A hyphen (-) may be used in place of a forward slash (/). /CheckF[ile] [Filespec] 5/Checkp[ointing] [{On | Off}] (On is the default) /Com[mandFile] Filespec /Conf[igFile] Filespec ./Conn[ection] IDOrName;ConnectionString /Cons[oleLog] [[DispOpts];[{E | I};List]] DispOpts = any one or more of N, C, O, S, G, X, M, or T. List = {EventName | SrcName | SrcGuid}[;List] /De[crypt] Password /DT[S] PackagePath -/Dump code[;code[;code[;...]]] /DumpOnErr[or] /F[ile] Filespec /H[elp] [Option] 1/L[ogger] ClassIDOrProgID;ConfigString */M[axConcurrent] ConcurrentExecutables /P[assword] Password /Rem[ark] [Text] /Rep[orting] Level[;EventGUIDOrName[;EventGUIDOrName[...]] Level = N or V or any one or more of E, W, I, C, D, or P. I/Res[tart] [{Deny | Force | IfPossible}] (Force is the default) '/Set PropertyPath;Value #/Ser[ver] ServerInstance /SQ[L] PackagePath /Su[m] /U[ser] User name /Va[lidate] */VerifyB[uild] Major[;Minor[;Build]] /VerifyP[ackageid] PackageID /VerifyS[igned] /VerifyV[ersionid] VersionID /VLog [Filespec] /W[arnAsError] /X86 `0S *H D0@1 0 +0h +7Z0X03 +70% <<<Obsolete>>>0!0 ++Q(V 10`0L .P\0 +0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 070822223102Z 120825070000Z0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0"0  *H 0 y}]E941%5IwEqFԌkLRbMIl/$>e# HuEP%+ #A$bEJͳ/"J-|o;99ݽ)f;-2'Hlc\򸔣8P'N0==l9.4. }bxfs Oc,2EJ;PSfQyV>Pn5{$Rf=N+~3nGўJnS00U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0U00Uvp[NQD.Dc0 U0 +{~J&μNtX't*uLxMi|CʇSŸVocDDȚ  )}s9=j8m҈#i 4|.)Bk(q8 ]hͽAkf4|zB{ p֒O8|-=4 b7j#\cZ9`U3; _,˫ 0  *RA^0(ip΀Brv0z0b a>0  *H 0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0 091207224029Z 110307224029Z01 0 UUS10U Washington10URedmond10U Microsoft Corporation1 0 U MOPR10UMicrosoft Corporation0"0  *H 0 0ErSkO#=Y@8s&S<B8auM\F^i[s)DdY/]nǫ9eħuꇗ&&v89&+ZT!򗍇)I,?}͖ q B5׸?ݎE }K[vrw#}5]PKGmUTN؁B1U SI0奈|^zZ7i2$00U% 0 +0U8xs2_Uƙt0U0U#0vp[NQD.Dc0DU=0;09753http://crl.microsoft.com/pki/crl/products/CSPCA.crl0H+<0:08+0,http://www.microsoft.com/pki/certs/CSPCA.crt0  *H ( oBvCB$e4uq0r7:pQ q(ps{V4ZrN {DO aun+Z 9`jT;1_,nM*v{Ƈֱ*rTn*ȞobKk=/zw9gj{cI&Bޕ" _s2r6)$ROfH&9iPNl.r!m$H@|t8JO00j O%EXzg0  *H 0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 060916010447Z 190915070000Z0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA0"0  *H 0 7nBJqH>S,2ORȃ>3I1(dPKuǨծipfx'f趷 Y")/@VvmdmJT޿ǀL7VhGv\/}%V[jc|<%M9wt]\؆7,u9 |vlnz>q_*Ob`2҃N+"\hE/Pl%ׅvs6ƕz`3[AXn,HoCj&k(0$0U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0 +70UoN?4K;AC0 +7  SubCA0 U0U00  *H M1|PapEsT? -QS9V ތ;ɷQ!oi~k"Flm|"Fӄ6~p]Eݎ*|ɮ2Շc6!v;s!شTeJ(&`;exHϭ:ObX099!dcC/{FeJtn ̝(a|H!8Ŗ2@S=f7"̰wTQ:rD#00 a00  *H 0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA0 080725190115Z 130725191115Z01 0 UUS10U Washington10URedmond10U Microsoft Corporation1 0 U MOPR1'0%U nCipher DSE ESN:85D3-305C-5BCF1%0#UMicrosoft Time-Stamp Service0"0  *H 0 -g%&bK08e46$h{b,FKQ4lZ;G=.5kE<fiJ',gbT'9هN`G#{'@ 15 ӋxaŵA>6X':ڽ]L0 +0 *H  1  +70 +7 10  +70# *H  1@?nҞI6arSg0X +7 1J0H&$SQL Server 2008 R2http://www.microsoft.com/sql0  *H dޠJy^m m!,ȌpfsfҞRCO0t+38wnsdy4N+b\ivp փ9R:k-(!NpA?}*%`=Q`PW5esD7/$ޏu&b0`"ҝ 0 *H  1 000y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA a00+]0 *H  1  *H 0 *H  1 100403180703Z0# *H  1z8Ԇ ZPŏg,0  *H WfẍD:˙/jN^Tq;cE]e?S}"4 i &*q5OlAǍVw<6ȓy4{ `] 89d?ee#Kl-ۆs>ocVUMH\%^ޤxꝓw$S0_&UѮe/U*ߨ'WH紑I #vcX?oT"2}D hbߖ-ްJuc2~ݺz