Parameter to DTS package

[FranklinYeung]

Hi,

Can i pass a parameter to a DTS package? What i want to do is to extract records to a text file according to the pararamters. I don't want to write code in my program because i believe SQL can output the file more quickly.

Or what can i do in SQL server to suit this requirment if the DTS package can't do the above job.

Many thanks!
:-D

Franklin

 

[aalmeida]

passing Parameter for DTS packages on run time is very limited, it has expanded a little on SQL 2k but still I think that if have something that may have to run frequently and is very dynamic you better off using Stored Procedures they can of couse be part of your DTS package that allows you to modify some behaviers on the DTS based on modifying the sprocs behavier within. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[tlbroadbent]

Check out global variables in DTS. The following links may provide information you need.

http://www.sqldts.com/article.asp?nav=1,6,205,7

http://support.microsoft.com/support/kb/articles/Q242/3/91.ASP

http://www.swynk.com/friends/green/textfile.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.