I am going to be setting up some Stored procedures that will be copying
data from a foreign database that will have an ODBC connection.
This task will need to be executed at night or from a .NET web page and
I was wondering what would the best way to copy the data from this
procedure.
It won't be necessarily be copying all the data from the database, but
could copy selected tables at different times.
Is this easily done from a Stored Procedure?
Thanks,
Tom.I would play with DTS if I were you. Seems a better candidate than a sproc
without using Linked Servers and such...
Greg Jackson
PDX, Oregon|||Jaxon wrote:
> I would play with DTS if I were you. Seems a better candidate than a sproc
> without using Linked Servers and such...
>
The question is, can it be run from ASP.NET? They want to run this
during the day when necessary, not just at a particular time of day and
don't want to run it from EM.
Tom.
> Greg Jackson
> PDX, Oregon
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment