Welcome to Sign in | Help

Re: executa dts dar schimba automat sursa - SQL Server 2005

  •  12-09-2008, 7:55 AM

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    B_gd_n[ ]Sahlean:
    Sintaxa de la DTSRUN este:
    C:\Documents and Settings\PestePrajit>dtsrun
    Usage:  dtsrun /option [value] [/option [value]] ...
    Options ('/?' shows this screen; '-' May be substituted for '/'):

      Package retrieval:
        /~S Server Name
        /~U User Name
        /~P Password
        /E <Use trusted connection instead of /U /P>
        /~N Package Name
        /~M Package Password
        /~G Package Guid String
        /~V Package Version Guid String
        /~F Structured Storage UNC filename (overwritten if /S also specified)
        /~R Repository Database Name <uses default if blank; loads package from repository datab

      Package operation (overrides stored Package settings):
        /~A Global Variable Name:typeid=Value <may quote entire string (including name:typeid)>

    unde

    /A global_variable_name:typeid=value

    Specifies a package global variable, where typeid = type identifier for the data type of the global variable. The entire argument string can be quoted. This argument can be repeated to specify multiple global variables. See the Remarks section for the different available type identifiers available with global variables.

    To set global variables with this command switch, you must have either Owner permission for the package or the package must have been saved without DTS password protection enabled. If you do not have Owner permission, you can specify global variables, but the values used will be those set in the package, not those specified with the /A command switch.


    şi

    The table shows the global variable data types and their IDs.

    Data type Type ID
    Integer (small) 2
    Integer 3
    Real (4-byte) 4
    Real (8-byte) 5
    Currency 6
    Date 7
    String 8
    Boolean 11
    Decimal 14
    Integer (1-byte) 16
    Unsigned int (1-byte) 17
    Unsigned int (2-byte) 18
    Unsigned int (4-byte) 19
    Integer (8-byte) 20
    Unsigned int (8-byte) 21
    Int 22
    Unsigned int 23
    HRESULT 25
    Pointer 26
    LPSTR 30
    LPWSTR 31


    Exista si DTSUI mie personal mi se pare mai simplu de folosit


    Secolul XXI ori va fi religios ori nu va fi deloc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems