Re: Best choice of technology

From: Cowboy \(Gregory A. Beamer\) [MVP] (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 08:55:46 -0500

For pure processing of data, I would consider creating a DTS task in SQL
Server. You can partially monitor it, so it may not be choice #1. In SQL
Server 2005, you have more monitoring options.

You can export DTS code to VB and set up a process to figure out where you
are.

With .NET you can make a service that runs these DTS processes. It will have
to use COM interop.

You can also roll your own DTS with a .NET service. The service option is
nice, as you can set up hooks to more easily monitor. The executable hooks
into the service and checks status, et al. 

-- 
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
************************************************
Think Outside the Box!
************************************************
"JohnFol" <Wibble@wobble.com> wrote in message
news:OE%23x6BCZEHA.808@tk2msftngp13.phx.gbl...
> I have a requirement to run some code on a server. The purpose of the code
> is purely to process data between an MS SQL box and a remote Oracle box.
It
> has no UI, and needs no user intervention to run.
>
> The 2nd part of the requirement is to have a UI that will allow an
operator
> to view the progress / current status of the processing. Even if the UI is
> not loaded, the processing must continue.
>
> I have a few ideas on how to tackle this, but would welcome opinions.
>
> Any ideas most welcome.
>
>

Relevant Pages

  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Failed when Sheduled
    ... Sql Server and my DTS are and it return this: ... One thing to note is that the "SQL Agent Proxy Account" is not the same as ... Perhaps you could have your DTS Package run WHOAMI.EXE with an Execute ...
    (microsoft.public.sqlserver.dts)
  • RE: Importing a DTS from Sql 2000 to Sql 2005
    ... Considering that DTS will not be supported in SQL much longer, and that SSIS ... The service account I mean the Sql Server Agent account is da which is a NT ...
    (microsoft.public.sqlserver.dts)
  • Re: is this possible.
    ... If you are asking can I easily build a package that one minute takes a SQL ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
Quantcast