I have never done a DTS package. I need to be able to look for a tab
delimiler file at a specific time, say 2 am, parse threw it and replace
records in the database. Is this possible, if so, is there any examples how
to do this

Dave

You can use SQL Server Agent to run at a certain time and invoke your
package. The package then gets the file.
I would then import the text file to a staging table. After you have it in
the staging table you can then use TSQL to do your update statements etc
inside of ExecuteSQL tasks.



--



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


"Dave" <davef (AT) helixpoint (DOT) com> wrote