I have a small app that does some file exporting from an SQL server.  On
this SQL server a DTS package is run to draw in data from a dBase
datasource.  In the application I have written a routine that will run
the DTS package on the server and report success or failure, the

I copied a package from server to another and now I can not open it on the
test server...I get the following error:
Invalid class string:
any ideas?

Is there any performance differences between the use of EXISTS and IN within
queries?

Running DTS from VB is new to me, so apologies for the newbie question.  I
have a DTS package which runs problem free in MMC.  I wanted to automate the
execution using VB6.  I've loaded the a Package2 object using the
LoadFromSQLServer method (which works fine), but the Execute ...

I need to repeatedly call 3 stored procedures (only the first 2 stored
procedure need to be called repeatedly) on a Sybase ASE 11 database to pull
data into a SQL Server database table (with different parameters):
e.g.

I need ideas on how to improve a process that can generate a terabyte of
data in a week. Our company produces software that analyzes code and one of
the things we do is Code Duplication. We're processing hundreds of millions
of lines against each other and generate gigabytes of ...

I know that GetExecutionErrorInfo doesn't work when called from within
a VB script.  So I downloaded the zip file that the ActiveXHelper COM object
from
http://www.sqldts.com/redir.aspx?45, and registered the ActiveXHelper DLL as

I am trying to determine if any of the step in package failed.  I am
executing a package from within an ActiveX script.  The execution of the
package works fine; however, when I try to retrieve the error information,
the call fails indicating Type missmatch or wrong number of ...

Does anyone know if there is a way to assign an owner and user password to
an existing DTS Package without having to do a saveas and give it a new
name.
Thank you,

what i want to do is a follows:
1. schedule a DTS package with timeout.but should not terminate the job.
2. when it timesout i want to send out a alert that the job has timed out
can anyone guide me on how to do this.

does nay one have a idea which tables r used by this sp

I have encountered this situation a number of times and wanted to see if
anyone else has run into it.
I have a few packages that primarily call other packages they are kinda a
loader package.  I create this new "loader" package and add one or more

I am creating a global temporary table by calling a stored procedure in one
of the steps in a DTS package. In another step, I am trying to fetch records
from the global temporary table. I am getting some errors here.
How to resolve this?

On my development DTS server, running Windows 2000 server, I have
-d:\Program files\DTSUtilities\Binn\DTSRun.exe, which has a version of
7.00.694
-d:\program files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe (SQL 2000's

I created a package on our dev server and can manually execute it OK from
Enterprise Manager, but when I schedule it, the job fails.
I'm having difficulty determining why this happens or where the error should
appear.  Are there common things I can check for, or settings I need to ...