Posted by David Portas on 02/01/06 12:47
Uncle Sam wrote:
> Build a job that imports a new version of MTL_PARAMETERS at 6pm each
> day. It should keep trying to import the table until it is successful.
> Care should be taken to avoid data model downtime.
Is this a SQL Server question? You could create a DTS package to import
the data and schedule that package with SQL Agent. Or use BCP
similarly. It really depends on what the data source is.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|