SQL Server Performance

DTS running

Discussion in 'SQL Server DTS-Related Questions' started by luma, Dec 2, 2005.

  1. luma New Member

    Hi , i have some stor procedure. During run of it i use package. But I need change some parameter in setting of package. Is it possible or may I run package in from .DTS file ?
    I need import XLS subor .
    Thanks, Lubo
    luma, Dec 2, 2005
    #2

  2. dineshasanka Moderator

    dineshasanka, Dec 2, 2005
    #2

  3. satya Moderator

    http://vyaskn.tripod.com/sql_server_dts_best_practices.htm

    hTH

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 4, 2005
    #2

  4. luma New Member

    Ok, but what is the best way for import XLS to SQL server ? Name of XSL is changed during run of procedure.
    Lubo
    luma, Dec 4, 2005
    #2

  5. Madhivanan Moderator

    Madhivanan, Dec 4, 2005
    #2

  6. luma New Member

    luma, Dec 5, 2005
    #2

  7. Madhivanan Moderator

    Yes. That will avoid you using DTS or Export/Import wizard

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Dec 6, 2005
    #2

Share This Page