Hi all,

im learning ASP.net and i want to be able to use DTS to load data into the
SQL Database using DTS, which i can using a fixed filename for example
"test.txt". does anyone know where there is a good example showing how to
pass a filename to the DTS package from runtime.


Regards
Simon

You can use a number of methods

1. DTSRUN and the /A switch
2. Dynamic Properties Task within the package
3. Setting the filename through code within the package
4. Use the ASP.Net application to get the name of the file and before
calling Execute() on the Package object you go in and change it through the
object model.


Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Simon Whale" <simon (AT) noway (DOT) ukdatait.com> wrote