Open the package in Designer.

Right click and select Package Properties.

In the Logging tab, enter an Error File to log your errors to a text file.

click "ok"

Save the package.

Run your package...

Here is a stored proc that i made to create a new DTS job, execute it and delete it on completion.. maybe it will give you some additional ideas to...

I'm fairly certain that if you modify your ADO call to the following, the insert will complete as expected.  -Mike Gercevich

With objCmd

     .ActiveConnection = objComm

     .CommandText = "proc_AddFile"

     .CommandType...

I have written a VB.Net app that will compare/move/update DTS Packages and allow for migration of packages between different servers... If you are interested in trying this utility out, send...

yes, it can be done.. but it is not as straight forward as you would guess it to be.  The basics are that you load a global text file into...

I do not believe that the layout/format of the structured storage file is documented.  I have looked for information on this topic to provide the ability to export task scripts...

Maybe this will help... I have written a .Net app that will allow a sysadmin the ability to compare DTS Packages between servers and copy a newer version or overwrite...

Assuming you have the SQLAgent running on your server, you could build a stored procedure to create a job and job step(s) that will execute and delete itself on success...

This should give your the same result as the code you posted by a single call to a stored proc.  Not sure why you are calculating the total column, and...

Just whipped this out, Try this.....Returns a rowset of servers.

--- Retrieve SQL Server List Via SQL-DMO Object Method call

CREATE PROCEDURE GetSQLServerList ()

AS

DECLARE @objSQLDMO    INT

DECLARE @objList      INT

DECLARE @ServerCount  INT

DECLARE @objMethod    VarChar(20)

DECLARE...

This looks to be a Command timeout.  The default is 30 seconds.  You can increase this on the command object before you call your execute method.

objCmd.CommandTimeout = 90 'in seconds

Do a Google search on "Bruce Szabo" and "DTS Store".  He is a good friend of mine that wrote a great article on this very subject.