Attaching Incremental data

I have a blank SQL database that will be generated with tables transferred
from an outside source. Once the tables are there, on a daily basis,
incremental data will be sent to an FTP folder in order attach them to the
original tables. What I need to know is how to attach the incremental data t
o
the tables. I know i'll probably schedule a job to run DTS to transform the
data from the FTP folder to the SQL server, then another job to attach the
incremental data once in SQL server to the tables. I need help with the
stored procedure I should use to attach the incremental data.
Thanks
TSTS,
Attach? I think you mean import. Anyway if there are not a ton of records
and you require some data manipulation then DTS would be the way to go. And
you're right scheduling the DTS package as a job will help automate the
import. You'll probably only need one DTS package/job to make this work.
As for the stored procedure help...that's pretty much impossible without
knowing your table structure, data, file format, etc... Please provide us
with more information as you get closer to implementing this solution.
HTH
Jerry
"TS" <TS@.discussions.microsoft.com> wrote in message
news:36C4AC57-E243-4FB1-BDE1-F1A3E3EE06A5@.microsoft.com...
>I have a blank SQL database that will be generated with tables transferred
> from an outside source. Once the tables are there, on a daily basis,
> incremental data will be sent to an FTP folder in order attach them to the
> original tables. What I need to know is how to attach the incremental data
> to
> the tables. I know i'll probably schedule a job to run DTS to transform
> the
> data from the FTP folder to the SQL server, then another job to attach the
> incremental data once in SQL server to the tables. I need help with the
> stored procedure I should use to attach the incremental data.
> Thanks
> --
> TS|||Refer to the post from earlier today titled: "Efficiently Inserting 1
Million records".
"TS" <TS@.discussions.microsoft.com> wrote in message
news:36C4AC57-E243-4FB1-BDE1-F1A3E3EE06A5@.microsoft.com...
>I have a blank SQL database that will be generated with tables transferred
> from an outside source. Once the tables are there, on a daily basis,
> incremental data will be sent to an FTP folder in order attach them to the
> original tables. What I need to know is how to attach the incremental data
> to
> the tables. I know i'll probably schedule a job to run DTS to transform
> the
> data from the FTP folder to the SQL server, then another job to attach the
> incremental data once in SQL server to the tables. I need help with the
> stored procedure I should use to attach the incremental data.
> Thanks
> --
> TS|||Thanks for your response. I'm just curious and I want to make some researche
s
from my side on how to import incremntal data to tables? If you can give me
a
general idea on how to do this or tell me if I can find any documentation on
this.
Thanks
--
TS
"Jerry Spivey" wrote:

> TS,
> Attach? I think you mean import. Anyway if there are not a ton of record
s
> and you require some data manipulation then DTS would be the way to go. A
nd
> you're right scheduling the DTS package as a job will help automate the
> import. You'll probably only need one DTS package/job to make this work.
> As for the stored procedure help...that's pretty much impossible without
> knowing your table structure, data, file format, etc... Please provide us
> with more information as you get closer to implementing this solution.
> HTH
> Jerry
> "TS" <TS@.discussions.microsoft.com> wrote in message
> news:36C4AC57-E243-4FB1-BDE1-F1A3E3EE06A5@.microsoft.com...
>
>