Is there a way to monitor all scheduled DTS jobs and restart the jobs
automatically when it faillS. If the job continues failing after being
restarted for several times then it must notify the responsible person. Is
there a tool that i can use with SQL to do this?

I' am importing jpg-files into a SQL2K database.
Currently I am using a staging table in wich I import the jpg's using
textcopy.
(first create the records with a placeholder in the image-field, then import

I am just starting with DTS. I am trying to import a text file into a table.
In this text file the field that maps to the primary key in the SQL table has
non-unique data (every row has this value set to 0).
So far I have only been using the wizard to try to get this done, but I

I'm trying to import an Excel 2000 file into a SQL Server 2000 table.  The
Excel file has 4 columns.  The database table mirrors these columns but has
an Identity field (called ID) which I have as PK to satisfy replication
requirements.  Also there is the replication field that ...

When I use Import/Export feature of SQL Server 2000 to migrate SQL Server
2000 database to Oracle, SQL Server converts all table names to something
like this:
"table name", instead of just table names without any quotes.

I have a VB.NET class that I need to call from a DTS package.  I need
to set a couple of properties and then call a method.
I've tried the activeX Script task but I can't seem to get it to work.
I used CreateObject but I think it wants a COM component.

I have an application that has aroubd 100 DTS Packages. I want to
backup my DTS packages.
Is there any easy way of exporting the packages other than that of
opening each package and saving it as a .dts file.

following a previous post...
Hi,
how can i retrieve in an ActiveX the SQLServer instance name where the DTS
is located.

I need to automate the execution of REPORTING SERVICES from DTS in SQL
Server 2000.
As most REPORTING SERVICES are exposed via SOAP, I need a basic/simple/old
fashion

By following the kb
http://support.microsoft.com/default.aspx?scid=kb;en-us;321525
If I don't set any globalVariable , then LoadFromSqlSever  and execute
method is fine.

In an DTS ActiveX I need to open an ADODB connection whose Data Source shoud
be the SQLServer instance where the DTS is located.
How can I retrive the instance name?
Thnx

I need to copy a file on another Windows server using a predefined UserAccount.
Is there a way to do this in DTS?
I don't believe I can use the FSO because it would not be connecting with
the correct user account.

I'm trying to bring a monetary value from an Oracle server into an SQL 2000
environment.  In the oracle table the monetary value displays with two
decimal places but when viewed in the SQL table it has rounded to no decimal
places.  It does not matter what data type I use when ...

I create a package to call other packages in one workflow ,it's very similar
as below:
Steps----on success--->step2----on success---->step3
                                    -

can any one help me with the below script.
I am getting error like
Error code = 0
Error Source = ADODB.recordset