DTS running | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS running

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
Check DTSRUN —————————————-

http://vyaskn.tripod.com/sql_server_dts_best_practices.htm hTH Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Ok, but what is the best way for import XLS to SQL server ? Name of XSL is changed during run of procedure.
See if this helps you
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail
Madhivanan , many , many thanks. There on http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 is very good idea for solving my problem. Lubo
Yes. That will avoid you using DTS or Export/Import wizard Madhivanan Failing to plan is Planning to fail