|
Home > Archive > MS SQL Server > October 2005 > updating records
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]
|
|
| Johnfli 2005-10-28, 11:23 am |
| I have a table that gets it's information from a txt file that it imports.
When it imports another txt file, I need it to UPDATE the records that have
a certain field (the primary field) that are the same.
I don't really do much with SQL so any help you can givve would be great.
Thanks
| |
| Thomas 2005-10-28, 1:23 pm |
| Well you could use a data driven task in DTS that would handle each record
loaded individually (I wouldn't recommend if the data set is large). Or you
could use DTS to load the file into a staging table then use that table to
update applicable records and add new ones as needed.
--
Thomas
"Johnfli" wrote:
> I have a table that gets it's information from a txt file that it imports.
> When it imports another txt file, I need it to UPDATE the records that have
> a certain field (the primary field) that are the same.
>
> I don't really do much with SQL so any help you can givve would be great.
>
> Thanks
>
>
>
| |
| Johnfli 2005-10-28, 1:23 pm |
| Either way sounds good to me.
ANd now for the next question:
How?
Or if you could point me to a website that might be able to show a small
example, that might be best.
"Thomas" <Thomas@discussions.microsoft.com> wrote in message
news:8B5BFCD4-21D3-4676-8D70- C8EE5DEBB30E@microso
ft.com...
> Well you could use a data driven task in DTS that would handle each record
> loaded individually (I wouldn't recommend if the data set is large). Or
you[color=darkred]
> could use DTS to load the file into a staging table then use that table to
> update applicable records and add new ones as needed.
> --
> Thomas
>
>
> "Johnfli" wrote:
>
imports.[color=darkred]
have[color=darkred]
great.[color=darkred]
|
|
|
|
|