Is this VBScript, or part of a compiled VB program?

You should be able to handle errors like this pretty easily using workflow within the package. Also, make sure that 'Fail...

Ahhh ... just guessing here ... but you'd probably need to provide a bit more detail about your situation before you'll get a useful answer.

I could say that you...

Could it be that little thing called syntax

For some commands the syntax requires (), for other it doesn't. This is part of the...

Take a look at this article.

http://www.sqldts.com/default.aspx?298

As I said in my previous post Error:  -2147467259 (80004005); means access denied. So yes there is a permissions problem.

When you execute the DTS manually it runs under your...

You will need to take the database offline and repair these errors. Continuing to use the database when it has consistency errors could compound the problem possibly even leading to...

Error:  -2147467259 (80004005);

This is the generic "Access Denied" message. So there is a permissions problem somewhere along the line. What account(s) are the SQL Server services (both Server...

As this is for SQL Reporting Services, you can do this very easily by defining seperate datasets for each of the items you need.

I suppose it all depends on what's output by the package.

I have a DTS package the has an ExecuteSQL step that updates a table prior to extracting the table to a...

Maybe a bit off track, but we're looking at how to get a series of XML files to update information in our SQL database. Came across a thing called DiffGrams. Here's...

How about the one used right here on SQLServerCentral.com

http://www.imceda.com/SQLTurbo_Description.htm

What is the definition of the table and the index? Maybe the record size is affecting the fragmentation.

I had one instance way back on SQL 6.5 where we had one...

Use the DTSBackup2000 tool available at http://www.sqldts.com/default.aspx?242

It has a command-line and GUI interface.

But isn't this the same approach to what the maintenance plan would do? Only difference is that it runs DBCC INDEXDEFRAG instead of DBCC DBREINDEX.

Better option is to run DBCC SHOWCONTIG...

Now why would you be using IPX/SPX ??

There is a knowledgebase article on this the 7391 error. I don't have the time to hunt it down at the moment,...