I'd like to know if there is a way to identify all the local packages that
refer to a specific table or specific stored procedure.
I know that the master and msdb databases contain special tables that can be
queried when examining database structures and executed jobs.

I am transferring records from one table to another table using a Datapump
task.each record looks like the following:
Field1 Field2 Field3 Field4
While transferring the field1 to 3 ,I update Field4 (it's my flag) and when

Is storing the package into the metadata services the only way to get the
DTS package excution time?
Thanks
Ray

Is there a way to stick something in the package's configured log from an
ActiveX Script? I've got a script that uses an external component to help
parse an XML document that's loaded from a text field in the source table.
If the document is invalid, I want to log the record's ...

we recently put in a DTS request to move 36 million records from a non SQL
Server to ours. At 33 million it failed, which was a bit annoying as it had
been running about 19 hours.
Is there a way of stopping it from rollbacking the records ?

           I am using SQL Server2000.
I want to use the "microsoft.xmlhttp" ActiveX Component in DTS Package
(using VB Script) By that method
“Set objXML = CreateObject("MICROSOFT.XMLHTTP") “

I am working with SQL Server 2000.
I need to search thousands of DTS packages across multiple servers to locate
those DTS Packages that reference a specific server.  The server is being
replaced and the server's name is  being changed to accommodate corporate

We are trying to run a job scheduled on SQL Agent that has only 1 step. The
step is an Operating System Command of:
DTSRun /s <Server> /n NEW Email Team Managers /e
which attempts to run a DTS package. The DTS Package itself has only 1 step

I'm trying to use the DTS package to run an UPDATE query but it looks like
the DTS query designer isn't accepting a properly formatted query.  I'm
looking at an example given on the Microsoft website that says I should use a
query like this:

Is there a documented/safe way to programmatically delete a DTS
package?
OK then, how about an undocumented way?
Thanks.

I set up a very simple Execute Process Task which runs a batch file on our
server's local drive.  The process works fine until I close and restart
Enterprise Manager.  Then when I attempt to execute the package (which
contains only 1 task - the "batch file" task), execution fails.  ...

DTSRUN is said to allow values to be passed-in to the DTS package. Books
Online has no complete example of this being done so I have to rely on the
syntax alone. Fine, but . . .
The syntax for DTSRUN  shows    /A global_variable_name:typeid=value.  but I

I keep getting the error
The number of failing rows exceeds the maximum specified
Insert error, column 16('DateX', DB_TYPE_DBTIMESTAMP),
status 6: Data overflow.  Invalid character value for cast

I have a WEB.NET  2003 program  service.   This service lets me check if a
file exists in the hard disk of the server,  if this is true a need to
execute some packages  that read text file and bring the information to SQL
tables.   Currently, I have structured storage file ...

i've an aplication called DTSBackup (Copyright © 1999 Darren Green) that i
don´t know if you've eard about. But this app backup one or more DTS into a
DIR and then u can restore them from there to another sqlserver instance.
Nothing new!