|
Home > Archive > MS SQL Server DTS > July 2005 > Is this possible
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| Allan Mitchell 2005-07-31, 8:24 pm |
| 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@helixpoint.com> wrote in message
news:O8KtlMilFHA.3936@TK2MSFTNGP10.phx.gbl...
>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
>
|
|
|
|
|