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
  2. dineshasanka Moderator

  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.
  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
  5. Madhivanan Moderator

  6. luma New Member

  7. Madhivanan Moderator

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

    Madhivanan

    Failing to plan is Planning to fail

Share This Page